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
Executing a stored procedure in after sql
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Wed Apr 02, 2003 7:09 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: