Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem with utl_file
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 Received on Thu Aug 01 2002 - 07:25:37 CDT
![]() |
![]() |