Re: Problem with utl_file

nn wrote:
>
> Hi
> i execute a PL/sql package with 2 methodes:
> 1-
> >export ORACLE_SID=MYORACLE_SID
> > sqlplus user/password @execute.sql
> PL/SQL procedure successfully completed
>
> --with execute.sql : execute mypkg.myprocedure(...)--
>
> 2-
> > sqlplus user/password_at_MYORACLE_SID @execute.sql
> *
> ERROR at line 1:
> 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 line 1
>
> what's wrong about "sqlplus user/password_at_MYORACLE_SID" ?, in 1 an 2 i have
> the same ORACLE_SID!! why have error in 2?
> Thank you

This would suggest the latter is connecting to a different database - which does not have the utl_file_dir set. You could confirm this by handling the individual exceptions that utl_file pops out

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."