DSXchange

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

Try using the syntax:

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

That should work.

Paul.

Thanks, that worked perfectly.

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