08-16-2005 10:00 PM
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
08-17-2005 4:49 AM
08-17-2005 4:49 AM
08-17-2005 5:34 AM
hi Matt,
search forum for this
i have seen many threads on this.
regards.
08-17-2005 8:41 PM
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