Native SQL for Abap connection with Oracle

Former Member — Mon, 12 Aug 2013 11:34:46 GMT

Hi Abap developers,

We need to connect SAP with an external Oracle database. We will need to read and to write Oracle database.

We create a simple report only to make some tests. The source code is the following. It is working fine.

But my question is where can i find a complete documentation about this Native SQL and samples with code about theses issues.

If you want purpose another way to connect the databases you will be welcome too.

Than you and best regards

JFernandes

*&---------------------------------------------------------------------*

*& Report ZTESTE_LIG

*&---------------------------------------------------------------------*

REPORT ZTESTE_LIG.

DATA: CONNECTION LIKE DBCON-CON_NAME VALUE 'VSALES'.

data: canal like VBRK-VTWEG.

data: begin of itab occurs 100,

aca_codemp type i,

aca_coddel type i,

end of itab.

EXEC SQL.

CONNECT TO :CONNECTION

ENDEXEC.

IF SY-SUBRC = 0.

EXEC SQL.

SET CONNECTION :CONNECTION

ENDEXEC.

refresh itab.

EXEC SQL.

SELECT ACA_CODEMP, ACA_CODDEL

INTO :ITAB

FROM

ZZ_ARTCANAL

ENDEXEC.

append itab.

loop at itab.

write: itab-aca_codemp, itab-aca_coddel.

endloop.

EXEC SQL.

SET CONNECTION DEFAULT

ENDEXEC.

EXEC SQL.

DISCONNECT :CONNECTION

ENDEXEc.

ENDIF.

Re: Native SQL for Abap connection with Oracle

ThomasZloch — Mon, 12 Aug 2013 12:19:40 GMT

You would probably need to look around on Oracle's web site to find such documentation of their SQL dialect.

Let me suggest you also check out ABAP database connectivity (ADBC) for this purpose, allowing to access external databases in an OO fashion:

http://help.sap.com/abapdocu_740/en/abenadbc.htm

Thomas

topic Re: Native SQL for Abap connection with Oracle in Application Development and Automation Discussions

Native SQL for Abap connection with Oracle

Re: Native SQL for Abap connection with Oracle