UNIX for Dummies Questions & Answers

Can someone tell me how to execute an Oracle Stored Procedure from a Korn Shell Script.

Previously, I'm able to execute standard sql using the following:-

The_Output=`sqlplus................. << EOF
select count(*) from abc
/
EOF`

Can I use sqlplus for the Stored Proc ?

Do I need to EXEC the Stored Proc ?

Any help much appreciated with this one !

V.

You dont need the back quotes and Yes you can use sqlplus to execute the stored procedure. Use a "here" document to execute your statement. You can embed both SQL and PL/SQL in the block. Here is a <<Link>> to a thread that may be of some benefit to you.

the '-s' option puts sqlplus in silent mode

sqlplus -s $USER_ID/$USER_PWD << SQLSTRING

#call package here
#or
#write your SQL and place the block
#inside here. Anything you put in here must
#be valid SQL syntax. Also, for your benefit,
#if you put PL/SQL in here, make sure that
#your DECLARE and END; are not indented
#or spaced in any way. They must be on
#the left margin.


SQLSTRING

you could EXEC the Stored Proc like this
sqlplus user/userpwd < /yourhomedirectory/your.sql

Further, you also do the following to execute your standard SQL statement.

sqlplus user/userpwd @/yourhomedirectory/your.sql