Hi All,
This is a very starnge problem I am having. I have a shell script that calls a stored procedure.

Here's my code in shell script:

sqlplus "userid/pwd" @file.sql

and file.sql has the following statement:

exec my_storedProc;

Now, when I execute my shell script, nothing happens, the stored procedure is NOT executed.

But, if I run the same stored procedure not as a script but, do a sqlplus "userid/password" on UNIX, it brings up the sqlplus prompt. Now if I manually type exec myStoredProc; , it runs just fine.

I do not know why it is happening. Also, I am able to run other stored procedures from shell scripts just fine. This is the only stored proceudre that is giving me problem.

FYI, my stored procedures access external tables. I checked permissions on the external tables and they have full access.

Any suggestions will be appreciated.