Hi,
I am trying to call a Stored Procedure (which have only text output, no input) from Advanced SQL (OS11), but it is not working.
I'm using something like this in Advanced SQL:
Begin
MyPackage.Procedure1();
End;
Can anyone help what I'm missing here?
Hi Biplabl,
Are you working on a cloud infrastructure or on an on-premises infrastructure?
If you are working on the cloud, it's not possible to call stored procedures.
If you are working on an On-Premises infrastructure, you can follow this step-by-step tutorial and check the How To Execute Store Procedures forge component based on the tutorial.
Kind Regards,João
Hi João ,
Thanks for your response.
It is a On-Premises infrastructure, I need to call an Oracle Store Procedure from OutSystems app. The SP is not in OutSytems database. I already have the connection with the external database (Oracle).
But not able to execute when it has no input parameters, but only output parameter (which returns a string)
Best Regards,
Biplab
Hi Biplab,
Ok, in that case, you can do that with an extension (check the success documentation from OutSystems on how to call external stored procedures).
Hi anyone,
I am developing a Reactive application where can I call stored procedures from external db MS SQL ? Could anyone please help me how to achieve that.
It would be good to call the procedures from SQL or build new functions in Outsystems.
Please anyone help me.
Thanks in advance.
Best regards,
Sohel Khan