plsql file find problem!

[helpme]

Hi,
This is a real vague problem..i dunno if it is a problem in the code.

file_id1 := utl_file.fopen('/usr/local/data','file1.ges','r');

Now I ve placed the file xactly in here.....But this file is never found


ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 101
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at "INSERT_INTO_TABLE", line 19
ORA-06512: at line 1

this is the error!!
can Any1 point out what it mite be?
Thax in advance

[jmodic]

What is your UTL_FILE_DIR init.ora setting?

[helpme]

No..actually it finds some file.....
But somefiles it doesn't...thats what amazes me!!

[shawish_sababa]

Hi

utl_file_dir identifies the directories that are permitted for us be a pl/sql procedur. each directory must be specified with a separate tl_file_dir paramater in the init.ora file. i think you have a problem there.

also, have you set any exceptions in your procedur? you can us a set of utl_file exceptions.

[helpme]

UTL_FILE.INVALID_OPERATION
it throws this exception

[shawish_sababa]

Hi

can user oracle write to '/usr/local/data','file1.ges'

[helpme]

Thanx buddy....
It worked....
so foolish of me...
thanx again

[shawish_sababa]

Hi

:-)

(for some unknown resone i can not copy smilys...)

[jmodic]

Originally posted by shawish_sababa
Hi

:-)

(for some unknown resone i can not copy smilys...)

Try to "write" your smilie without the nose (live the minus sign out). Or check the follwing link for all standard available smilies in this forums:
http://www.dbasupport.com/forums/ind...on=showsmilies

[shawish_sababa]

thank's