Oracle Stored Procedure Simple

Oracle Stored Procedure Simple

  

hi there,

I want to call a stored procedure in a outsystems. Where can i find a simple and step by step tutorial? 

tq in advance..

Solution

indra budiantho wrote:

hi there,

I want to call a stored procedure in a outsystems. Where can i find a simple and step by step tutorial? 

tq in advance..

Hope this below links help you

http://www.outsystems.com/help/servicestudio/9.1/index.htm#t=APIs%2FRuntimePublic_API%2FUse_Cases%2FCall_a_Stored_Procedure.htm

http://www.outsystems.com/forge/component-discussions/974/How+To+Execute+Stored+Procedures

Regards,

Swaroop

Solution

Swaroop Mutalik wrote:

indra budiantho wrote:

hi there,

I want to call a stored procedure in a outsystems. Where can i find a simple and step by step tutorial? 

tq in advance..

Hope this below links help you

http://www.outsystems.com/help/servicestudio/9.1/index.htm#t=APIs%2FRuntimePublic_API%2FUse_Cases%2FCall_a_Stored_Procedure.htm

http://www.outsystems.com/forge/component-discussions/974/How+To+Execute+Stored+Procedures

Regards,

Swaroop


OK, tq...it works:

1. i download the oracle connector for P9 as my version is P9.1

2. i open it in the integration studio

3. i manage dependencies in service studio to include it

4. i put the properties: connection name as known in outsystems platform, the package name (must create a package) and the function name, although without parameters.

5. drag the connection action in my screen action flow (on click button)