close command in oracle enterprise stage

[vishnuvyas]

Hi,

Please give me extact syntax for using the close command in oracle enterprise stage.
I am trying to execute a stored procedure after loading the data in the table but it is giving invalid close command errror.

I am using the statement

'exec proc_name;'

Please help.

[sureshabbisetti]

The Open/Close command are used to execute the Sql statements before/after loading the target tables like truncate tale etc... . To execute the stored proc use unix shell script & call that procedure in sequence by using Execute Command activity stage.

Regards
Suresh