Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with utl_file

Problem with utl_file

From: nn <nn_at_n.com>
Date: Thu, 1 Aug 2002 14:25:37 +0200
Message-ID: <aib9co$mvj$1@s1.read.news.oleane.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US