Oracle Enterprise : Fatal Error: Invalid open command

[suresh.angadi]

Hi,

I have requirement to truncate data and drop index before loading data into one of the oracle table.
I used Oracle Enterprise stage and given to statements in open command (first i tried both statements seperated by semicolon, and also without semicolon) but fot the error

Oracle_Enterprise_24,1: Fatal Error: Invalid open command: call truncate_tabs('MCFDS_AGENT_XREF_HIST')

call PRC_DROP_INDEX ('CFDSYSDB','IX1_MCFDS_AGENT_XREF_HIST').

Can any one suggest how to use multipule statement in open command option in Oracle Enterprise Stage.

Regards
Suresh Angadi

[madhukar]

try using anonymous plsql block