DB Connect and Database Views

[Former Member]

Hello,

I am writing a function module to access an external Oracle database that has been defined in our ABAP system using DBConnect.

I would like to use Open SQL instead of Native SQL to access the data in the remote table. Is this possible? I believe that in order to do this, a view of the remote table would have to be defined in the ABAP data dictionary via SE11, but I am unable to do this.

Does anyone know if this is possible, or am I required to use Native SQL when accessing an external database?

Regards,

-Matt Schababerle

[Former Member]

Hi,

Chek out these two links.

It would be helpful:

Regards,

Anjali

[Former Member]

hi Matt,

search forum for this

i have seen many threads on this.

regards.

[Former Member]

Thanks very much! I looked for threads on native SQL, but did not search past the begining of this year. The link was exactly what i was looking for!

-Matt