invoke oracle package error?

andrewknight · #1 (**permalink**) 07-29-2008

My sh scripts is :

sqlplus -S "user/pwd@server" <<!!
SET SQLPROMPT
exec IN_PROC_TEST;
!!

It prompt 'PL/SQL procedure successfully completed.' but not execute actually

I run this procedure in sqlplus, no problem
and I also could execute simple DDL in this sh script, but why could not execute this procedure in sh?

Thanks a lot!

andrewknight · #2 (**permalink**) 07-29-2008

oh!

on problem run this in sqlplus locally
however,after logon remote server and run this in sqlplus, also prompt ''PL/SQL procedure successfully completed',but no run actually

andrewknight · #3 (**permalink**) 07-29-2008

Error Prompt:
SQL> BEGIN
2 EXEC IN_PROC_TEST;
3 END;
4 /
EXEC IN_PROC_TEST;
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00103: Encountered the symbol "IN_PROC_TEST" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "IN_PROC_TEST" to continue.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to restore original package after uninstalling the upgraded package using rpm	amitpansuria	Linux	0	05-27-2008 05:08 AM
package error	Rasmita	UNIX for Dummies Questions & Answers	0	01-10-2008 07:19 AM
package error	murad.jaber	SUN Solaris	1	06-06-2007 10:59 AM
Capturing Oracle Shutdown error	ganapati	UNIX for Advanced & Expert Users	15	04-19-2007 09:26 AM
[help]oracle database error on solaris 8	bucci	SUN Solaris	5	12-02-2006 10:58 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by