topic Oracle Query From ABAP Program in Application Development and Automation Discussions

Oracle Query From ABAP Program

Former Member — Thu, 26 Feb 2009 17:08:36 GMT

Hello everybody,

I have a doubt about if I can do a Query to a External Oracle Database to get some records and then process them in my ABAP Program, is this possible?, if this is the case can anyone help me with some documentation, thanks in advance for your answers.

Regards,

Julio

Re: Oracle Query From ABAP Program

Former Member — Fri, 27 Feb 2009 16:51:24 GMT

Hi Julio,

you can use the open SQL connect statement


EXEC SQL. 
  CONNECT TO dbs [AS con] 
ENDEXEC.

or even you can define the DB in the FROM with the option CONNECTION


... FROM { {dbtab [AS tabalias]} 
         | join 
         | {(dbtab_syntax) [AS tabalias]} } 
         [UP TO n ROWS] 
         [CLIENT SPECIFIED] 
         [BYPASSING BUFFER] 
         [CONNECTION {con|(con_syntax)}] ... .

Hope it helps,

Edgar