Recent content by mgpr

Yeah, you was right, path was invalid: ORA-20000: INVALID_PATH exception attempting to open "\\PCID75\Temp" ORA-06512: at "TRVP.NA_IMPORT_PROC", Line 20 ORA-06512: at Line 1 so, you got any idea i could put this file from a blob(table) down to filesystem at unix-server...

i did copy this line and forgot to correct it right, should be: '\\pcID75\e$\temp' and there should be np to access to this folder. But without exception i will got following errors: SQL> execute na_import_proc; BEGIN na_import_proc; END; * FEHLER in Zeile 1: ORA-06510: PL/SQL: Unbehandelte...

got a problem with a procedure listen below. there compalition will be without errors, but after i will execute it, it will just run into exception mode 'Fehler3' Create table na_import (NETZ varchar2(100), IO2 varchar2(100), IO3 varchar2(100), IO4 varchar2(100), IO5 varchar2(100), IO6...

thanks for your help DoubleH

How i could convert bfile's and blob's into clob's with PL/SQL. I got table with a bfile and blob, sometimes there are only text files and it would be much easier to work with them when they would be in clob format, so how i could insert/select them into another table with clob's? thanks mike

SOME TIPS ON WHICH FUNCTION I SHOULD LOOK, WOULD ALSO HELP

WOULD NEED THEM FOR CLOB'S AND FOR BLOB'S DATES! FUNCTION TO RUN A JOB DURING NIGHT ON SERVER(HPoX-Unix) WOULD BE ALSO A REAL GOOD ADD.

I HAVE TO DEVELOP AN AUTOMATIC IMPORT PROCESS WHERE CSV-FILES WILL BE IMPORTET. WITH SQLLOADER YOU CAN IMPORT THAT MANUELL BUT I WOULD NEED A METHODE TO IMPORT THEM AUTOMATIC SO I CAN RUN APPLICAITON ON A SERVER(HPOX) WHERE DATA WILL BE IMPORTET AT NIGHT. I HEART ABOUT SOMETHING WHERE YOU CAN...