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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.