Executing a stored procedure in after sql

rgilmore · Post by **rgilmore** » Thu Oct 16, 2003 8:21 pm

The sql statement is: EXECUTE APPL_TOOLS.ANALYZE_TABLE('RGILMORE','b_acct_tran_eod'); This stored procedure works fine when I run the procedure in sql plus. RGILMORE is the owner parameter and the b_acct_tran_eod is the table name.

The error I'm getting is: ORA-00900: invalid SQL statement

Is there something I need to add in order for data stage to submit a valid sql statement?

Thanks,
Robert

Paul Preston · Post by **Paul Preston** » Fri Oct 17, 2003 4:27 am

Try using the syntax:

CALL APPL_TOOLS.ANALYZE_TABLE('RGILMORE','b_acct_tran_eod');

That should work.

Paul.

rgilmore · Post by **rgilmore** » Fri Oct 17, 2003 10:21 am

Thanks, that worked perfectly.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 17, 2003 8:18 pm

You usually need CALL to invoke a stored procedure from an ODBC, or ODBC-based, client.