Oracle Query From ABAP Program

[Former Member]

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

[Former Member]

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