Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Trigerring a stored procedure using ABAP

Former Member

‎2008 Dec 29 6:40 AM

0 Likes
497

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

*

o Answers will be rewarded with points

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

*

o Answers will be rewarded with points

Reply
1 REPLY 1
Read only

Former Member

‎2008 Dec 29 7:17 AM

0 Likes
371

Dear Manikandan,

The statement EXECUTE PROCEDURE calls a procedure proc stored in the database. For all formal parameters of the procedure, you must specify the actual parameters, separated by commas. You must specify IN, OUT, or INOUT before every actual parameter, in order to indicate whether the parameter is an input, output, or input/output parameter. You can use literals or host variables labeled by a colon ( for the actual parameters. When internal tables are used they must be standard tables without secondary table keys.

The codel below should help you:

EXEC SQL. 
  EXECUTE PROCEDURE proc ( IN    p_in1    IN    p_in2 ..., 
                           OUT   p_out1   OUT   p_out2 ..., 
                           INOUT p_inout1 INOUT p_inout2 ... ) 
ENDEXEC.

Regards,

Nimish