topic Re: Opening Oracle database connection through ABAP Program in Application Development and Automation Discussions

Opening Oracle database connection through ABAP Program

Former Member — Wed, 21 Oct 2009 10:21:24 GMT

I am trying to connect to Oracle database using NATIVE SQL in ABAP Progarm. For this we have maintained DBCON Table

While executing the statement , CONNECT TO :V_CONN of following code, it is giving sy-subrc = 4.

v_conn = 'MMKNDPAY'.

EXEC SQL.

CONNECT TO :V_CONN

ENDEXEC.

What is required to be maintained in CON_ENV Field of DBCON Table for Oracle server.

Please Help.

Former Member — Wed, 21 Oct 2009 10:27:00 GMT

U make sure SAP system can reach the oracle database else it's useless to fill the DBCON table, I've never filled that field

Max

former_member222860 — Wed, 21 Oct 2009 10:33:01 GMT

I think, it is 3 char <SID> of the database server.

ex: DEV

Former Member — Wed, 21 Oct 2009 11:02:00 GMT

Hii Max,

Can you please provide us some documents which will give the step by step procedure to how to connect to the external oracle database using DBCON.

We have already made the entry in DBCON Table. Please let us knw what else setting needs to be done.

Thanks in Advance.

Edited by: Jagdish More on Oct 21, 2009 5:20 PM

Former Member — Thu, 22 Oct 2009 09:26:11 GMT

Try see here [https://cw.sdn.sap.com/cw/docs/DOC-39830]

Max