topic Re: Connection with Oracle in Application Development and Automation Discussions

Connection with Oracle

Former Member — Thu, 26 Mar 2009 09:53:41 GMT

Dear,

I want to access and read from Oracle 9i tables from SAP.

How can i do this.

Do i have to do anything from basis side or write a connection string in ABAP.

Regards,

Priya

Re: Connection with Oracle

Former Member — Thu, 26 Mar 2009 10:00:08 GMT

Check SAP note 323151

Re: Connection with Oracle

Former Member — Thu, 26 Mar 2009 10:24:11 GMT

Hi Priya,

First of all check whether DB connection is done from transaction DBCO. If no connection is made then ask your basis team to do this.

Then is your program were you want to read the table from oracle 9i write a code like this:

The table can be read with the help of declaring a cursor type data.

EXEC SQL.
  CONNECT TO 'MYCONNECTION' " Name of DB connection
ENDEXEC.
EXEC SQL.
  open c for
    SELECT * from PVACCOUNTBALANCE2
ENDEXEC.
DO.
  EXEC SQL.
    FETCH NEXT c INTO :ithead " internal table for data
  ENDEXEC.
  append ithead.
  IF sy-subrc ne 0.
    EXIT.
  ENDIF.
ENDDO.
EXEC SQL.
  CLOSE c
ENDEXEC.
EXEC SQL.
  DISCONNECT :'MYCONNECTION'
ENDEXEC.

I hope this answers your query.

Regards,

Brajvir

Re: Connection with Oracle

Former Member — Tue, 02 Jun 2009 04:59:48 GMT

Hi Brajvir,

What is the declaration of the Internal Table ?

Re: Connection with Oracle

Former Member — Tue, 02 Jun 2009 05:04:25 GMT

Dear,

It is same as normal internal table we declare for abap programming.

Regards,

Priya

Re: Connection with Oracle

Former Member — Tue, 02 Jun 2009 05:07:19 GMT

hi Priya,

i mean, what is the structure of the iternal table. Do we need to declare the fileds in the internal table having the same structure of remote server table stucture ?

Re: Connection with Oracle

Former Member — Tue, 02 Jun 2009 05:18:25 GMT

Yes u will have to declare the same structure that of remote server table.

Regards,