Opening Oracle database connection through ABAP Program

[Former Member]

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]

Hi

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]

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

ex: DEV

[Former Member]

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]

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

Max