|
Calling a pl-sql procedure |
|
|
|
|
Written by Pavan
|
|
Thursday, 26 April 2007 |
|
To call a pl sql procedure in ABAP, we need to use native sql statements as follows:
1. DB Linkwith the help of basis team, if some db link is created in R/3 database, then something can be done.using @dblinkname. 2. eg. report abc. exec sql. BEGIN MYPROC@mydblink('2102'); COMMIT; END; endexec. EXEC SQL.SET CONNECTION DEFAULTENDEXEC. EXEC SQL.CONNECT TO 'TOMAS3' AS 'con'ENDEXEC. EXEC SQL.SET CONNECTION 'con'ENDEXEC. ** call to the stored procedure that updates the external DBEXEC SQL. EXECUTE PROCEDURE RefrescaCOPdeSAP_JOBSAP2 ( IN :g_input )ENDEXEC. EXEC SQL.DISCONNECT 'con'ENDEXEC.
|
|
Last Updated ( Thursday, 26 April 2007 )
|
