|
-
hi,
to my knowledge the error message returned by oracle is not correct.
am i correct.
In this example i hv not given the path, i hv not opened the file.
when am i suppose to get this error message????
"User-Defined Exception"
SQL> ed
Wrote file afiedt.buf
1 declare
2 s varchar2(10);
3 ftyp UTL_FILE.FILE_TYPE;
4 begin
5 s:='abc';
6 utl_file.put_line(ftyp,s);
7 exception when others then
8 dbms_output.put_line('err >>> '||sqlcode||sqlerrm);
9* end;
SQL> set serverout on
SQL> /
err >>> 1User-Defined Exception
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|