Trigerring a stored procedure using ABAP

[Former Member]

Hi,

Can we trigger a store procedure on Oracle database using ABAP program.

our case is that we are using the stored procedure which was used in source system oracle DB in SAP BI oracle database, we need to schedule this stored procedure.

Regards,

Mani

• Answers will be rewarded with points

[stefan_koehler]

Hello Mani,

you can use the the native SQL "interface" for that:

http://help.sap.com/saphelp_470/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

EXEC SQL
  EXECUTE PROCEDURE <YOUR_PROCEDURE>
ENDEXEC.

Regards

Stefan