| Error invalid directory path in oracle 10.2 [message #395647] |
Thu, 02 April 2009 02:40  |
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);
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
