Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fnd_File.Put_Line Error Issue.

546215Feb 2 2007 — edited Feb 2 2007
Hi,

I am using sql developer version 5.1.3.704 connecting to oracle 8i database.I have developed a procedure which would take unix path as i/p parameter(should be registered in ult_file_dir) to write the files. when an invalid path is given by the user,it goes in to the error handling block as shown below.. p_filedir is the i/p path to be given.

BEGIN

po_recon_sd1 := UTL_FILE.FOPEN(P_FILEDIR, 'po_recon_sd1', 'w');
....
....

EXCEPTION

WHEN UTL_FILE.INVALID_PATH THEN

Fnd_File.Put_Line(Fnd_File.Log, 'Invalid Output Path');

/*DBMS_OUTPUT.PUT_LINE('Invalid Output Path ' || p_filedir);*/

END;

but when invalid path is given it will enter the exception block and in case of DBMS_OUTPUT.PUT_LINE it would give the error message when run from backend.when this procedure is registered as a concurrent program in APPS it should give the error message in log file.But Fnd_File.Put_Line is throwing 'ORA-06510 PL/SQL undefined user defined exception' even the syntax for Fnd_File.Put_Line looks fine what could be the reason.. kinly help me out on this one

Thanks & regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2007
Added on Feb 2 2007
2 comments
1,016 views