Stored Procedure in Direct SQL

[muthaharotm]

Dear All,

How to use stored procedures in Direct SQL Update of Automation Agent, Could any one help me.

Thanks and Regards
Muthahar

[bmj_23]

Re: Stored Procedure in Direct SQL

Hi Muthahar - this can definitely be done. I worked on a project where we used standard packages (rather than stored procedures) within the OTM workflow but I dont have the details to hand unfortunately.

You should probably refer to the Technical Consultant or the DBA that is involved on your project for the best advice on how to implement what you are looking to do (I seem to remember there were quite a few guidelines that our TC gave us when we did something similar).

[cunninghamg]

Re: Stored Procedure in Direct SQL

To call a package from a agent:

Add a DirectSQL
In the Sql Statement box call the procedure..
(eg call glogowner.pkg_package.detail_name)

Set the Statement Type to Stored Procedure

That's it

Cheers
Gary

[garofalof]

Re: Stored Procedure in Direct SQL

don't forget to grant the procedure to GLOGADMIN