SQL & PL/SQL

Hi All,

I have a stored procedure to load data into a table from another table. When I execute it using the EXEC command, I am getting the expected result.

But when I try to invoke the same using a Unix shellscript by connecting to the DB thru the script, I am getting the exception:

ORA - 20010.

I have checked the shell script for any errors, and its fine. The same script is being to invoke other stored procs and they are working properly .

Please suggest a solution.

Thanks.