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.
Is it possible to access an ORACLE table and fetch data from using JDBC (Java DataBase Connectivity). If it is, could anyone tell me what command/function module etc to use in ABAP (sample code will be highly appreciated).
You can try with EXEC and ENDEXEC to fetch the data using Native SQL.
DATA: BEGIN OF WA,
CLIENT(3), ARG1(3), ARG2(3),
END OF WA.
DATA F3(3).
F3 = ' 1 '.
EXEC SQL.
SELECT CLIENT, ARG1 INTO :WA FROM AVERI_CLNT
WHERE ARG2 = :F3
ENDEXEC.
WRITE: / WA-CLIENT, WA-ARG1.
You can try with EXEC and ENDEXEC to fetch the data using Native SQL.
DATA: BEGIN OF WA,
CLIENT(3), ARG1(3), ARG2(3),
END OF WA.
DATA F3(3).
F3 = ' 1 '.
EXEC SQL.
SELECT CLIENT, ARG1 INTO :WA FROM AVERI_CLNT
WHERE ARG2 = :F3
ENDEXEC.
WRITE: / WA-CLIENT, WA-ARG1.
Thanks for both of your answers. But actually the question I asked is how to establish the connection (the table is sitting outside SAP). My understaning is to access the table, we have to establish a connection (probably JDBC) between SAP and the table. Otherwise how will the native SQL EXEC-ENDEXEC work for that table?
Hi Sandip. To connect to a secondary database, you use the EXEC SQL command. You first must configure a database connection on DBCO transaction. There you specify the ODBC for the connection, you could use Oracle, MSSQL, DB2, etc; you also specify the server name, user and password... Then, on your program you use:
EXEC SQL
CONNECT dbcon
ENDEXEC
EXEC SQL
OPEN CURSOR dbcur FOR
SELECT * FROM table
ENDEXEC
EXEC SQL
DISCONNECT dbcon
ENDEXEC
That's a very simple example. Check out the help on these sentence.
Hi Sandip. I've use DBCO to connect to an MSSQL Server DB, however in Conn.info you should put the values to connect to the oracle database. You may wanna check the note 339092:
Connection name: logical name of the connection
DBMS: ORA
User name: Oracle users
DB password: password for the above-mentioned
Oracle user
Conn.info: TNS alias
Permanent: Usually should not be set for a secondary connection.
Bluesky
