how insert data to oracle data base from SAP through procedure

former_member526551 — Mon, 10 Mar 2014 11:44:44 GMT

hi Experts,

Iam able to insert data from SAP to orcale database table:'MAKT' whicah was created in the orcale with the similar sap fields from SAP as follows:

LOOP AT gt_makt INTO wa_makt.
    EXEC SQL.
      INSERT into makt@VCPD_LINK1
             ( MATNR, SPRAS, MAKTX, MAKTG )
      VALUES ( :wa_makt-matnr, :wa_makt-spras, :wa_makt-maktx, :wa_makt-maktg )

    ENDEXEC.
    EXEC SQL.
      COMMIT
    ENDEXEC.
   CLEAR wa_makt.
ENDLOOP.

And now i want to insert data to procedure:'MAKT_DATA' created in Oracel side as follows:

CREATE OR REPLACE PROCEDURE MAKT_DATA(

iMATNR VARCHAR2,

iSPRAS VARCHAR2,

iMAKTX VARCHAR2,

iMAKTG VARCHAR2

) AS

BEGIN

INSERT INTO MAKT (MATNR, SPRAS, MAKTX, MAKTG)

VALUES(iMATNR, iSPRAS, iMAKTX, i MAKTG)

;

END MAKT_DATA;

please let me know the code to insert the the data from my sap proragm to the above procedure:MAKT_DAT.

Thanks,

Sivagoapl R.

Re: how insert data to oracle data base from SAP through procedure

Former Member — Tue, 11 Mar 2014 12:59:19 GMT

Try following code, if you are connecting to the default underlying database of SAP ECC, try the following code:

LOOP AT gt_makt INTO wa_makt.
EXEC SQL.
begin

MAKT_DATA( :wa_makt-matnr, :wa_makt-spras, :wa_makt-maktx, :wa_makt-maktg );

end;

    ENDEXEC.
    EXEC SQL.
      COMMIT
    ENDEXEC.
   CLEAR wa_makt.
ENDLOOP.

if the above code not working try removing begin and end;

topic Re: how insert data to oracle data base from SAP through procedure in Application Development and Automation Discussions

how insert data to oracle data base from SAP through procedure

Re: how insert data to oracle data base from SAP through procedure