same structure we create the sap table and oracle table.
and create the Database Connection in sap and same name create the Oracle .
if that connection available or not check the table 'DBCON' i have some example code give bellow
REPORT zmpq_sap_to_oracle.
TABLES: zmpq_cc_all_job,dbcon.
DATA: BEGIN OF i_job OCCURS 0.
INCLUDE STRUCTURE zmpq_cc_all_job.
DATA: END OF i_job.
DATA sap_web LIKE dbcon-con_name VALUE 'WEBOS'.
BREAK-POINT.
START-OF-SELECTION.
SELECT * FROM zmpq_cc_all_job INTO TABLE i_job.
EXEC SQL.
SET CONNECTION :sap_web
ENDEXEC.
EXEC SQL.
CONNECT TO :sap_web
ENDEXEC.
IF sy-subrc <> 0.
MESSAGE 'NOT Connected..!!' TYPE 'S'.
LEAVE PROGRAM.
ENDIF.
EXEC SQL.
INSERT INTO noti_details (QMNUM) VALUES ('8888888')
ENDEXEC.
whether using the base on your example
by
imuthu
Bluesky
