Tags: connecting, database, developed, error, fnd_fileput_line, mysql, oracle, path, procedure, sql, unix, version
Fnd_File.Put_Line Error Issue.
I am using sql developer version 184.108.40.2064 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.
po_recon_sd1 := UTL_FILE.FOPEN(P_FILEDIR, 'po_recon_sd1', 'w');
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);*/
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
Leave a comment...
- 2 Comments
- Errr, doubt if it has anything to do with sqldev. You'll get more response in the PL/SQL forum...
PS1: sql developer version 220.127.116.114 ? what program are you really using?
PS2: also remember 8i is not supported (at least officially)#1; Sat, 23 Feb 2008 15:59:00 GMT
- version 18.104.22.1684?
What application are you using again? SQL Dev is on 1.1...
Eric#2; Sat, 23 Feb 2008 16:00:00 GMT