calling oracle stored procedure

msa02

Hi,
I'm doing datadeploy from xml to db. When this deployment is finished, i need to invoke an oracle procedure. I understand this can be done by having a second deployment. The DD documentation doesn't clearly say how to call / execute a strored procedure. Could somebody explain how to accoplish this.

Thanks!
msa02

Migrateduser

Here's what the config file would look:
....
.....
<deployment name="dassql">
<destinations>
<!-- Oracle database -->
<database use ="oracle"
table = "not-used-by-this-dosql-deployment">
<sql user-action="execute_my_procedure" type="exec-proc">
procedure_name(parameters)
</sql>
</database>
</destinations>
</deployment>
....
....

Example:

If you want to execute a stored procedure called 'proc2' that
takes two parameters (integer, character), the DataDeploy config file for the action looks like:

For Oracle, Informix and Sybase SQLAnywhere:

<sql user-action="execute_my_procedure" type=exec-proc>
proc2(1,'testval')
</sql>

How to invoke:

iwdd.ipl deployment=<deployment> cfg=<cfg file> iwdd-op=sql user-op=execute_my_procedure

Result of executing the stored procedure is reported as either successful or failure.

Give this a try and let me know if it does what you want to accomplish.

Susan