Home » SQL & PL/SQL » SQL & PL/SQL » Error invalid directory path in oracle 10.2 (oracle 10.2.0.3 - win32)
Error invalid directory path in oracle 10.2 [message #395647] Thu, 02 April 2009 02:40 Go to next message
sammeras
Messages: 28
Registered: September 2007
Location: Israel
Junior Member

Hello,
I run this script in oracle 9i (on windows), and it run good.
When i take the same script, and run it under 10.2.0.3 (on win32), i get error:
Please see the error and the scripts.

When i used directory, it's work fine, but i can't change the script, cuz the same script run under 2 oracle servers (9i,

10g)

Thanks,





Begin 
    IMPORT_TRANSACTION_FILE_V03 (PPath=> 'e:\tax\inputfiles\',  PFile_name=> 'BKSTX.DAT'); 
End;
/


----- The error when run from oracle 10.2.0.3
Error at line 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "TAX_BLL_DEV.PROCESS", line 219
ORA-29280: invalid directory path
ORA-06512: at "TAX_BLL_DEV.IMPORT_TRANSACTION_FILE_V03", line 252
ORA-06512: at line 2



---------- the PROCESS script body
TAX_BLL_DEV.PROCESS ---> line 219
WHEN utl_file.invalid_path THEN
DBMS_OUTPUT.PUT_LINE ('IN CHECK - UTL FILE ERROR >> invalid_path'); 
line 219 --> RAISE File_Not_Found;


-------- the IMPORT_TRANSACTION_FILE_V03 script
TAX_BLL_DEV.IMPORT_TRANSACTION_FILE_V03 ----> line 252
if PCheck Then
dbms_output.put_line ('In Check !!');
line 252 ----> Process.Check_File_Header (PFile_Name, PPath, VPID, Sysdate, VFileSeq, VFileDate, VDelete);


Re: Error invalid directory path in oracle 10.2 [message #395649 is a reply to message #395647] Thu, 02 April 2009 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either your directory is not in UTL_FILE_DIR parameter list, either Oracle has no access to it.
You should use Oracle directory instead of utl_file_dir list.

Regards
Michel
Re: Error invalid directory path in oracle 10.2 [message #395676 is a reply to message #395647] Thu, 02 April 2009 04:03 Go to previous message
sammeras
Messages: 28
Registered: September 2007
Location: Israel
Junior Member

Thank you ..works Smile
Previous Topic: prevent the data from update,insert,delete
Next Topic: How to wait for trigger to complete (merged)
Goto Forum:
  


Current Time: Tue Dec 06 08:27:51 CST 2016

Total time taken to generate the page: 0.10488 seconds