topic ABAP native SQL in Application Development and Automation Discussions

ABAP native SQL

Former Member — Fri, 30 Sep 2011 09:18:10 GMT

Guys,

Did anyone know how Oracle synonym works with ABAP native SQL?

I have a database in oracle with a predefined synonym already used in ABAP code.

Now i want to change the current synonym to point towards a new database in oracle, my doubt is, are these synonyms point to the oracle table level or they point to the entire database?

Regards,

Sudeep

Re: ABAP native SQL

Former Member — Fri, 30 Sep 2011 09:27:48 GMT

Hi ,

You can use native SQL as below

EXEC SQL.

INSERT INTO scarr

(MANDT, CARRID, CARRNAME, CURRCODE, URL)

VALUES ('000', 'FF', 'Funny Flyers', 'EUR',

'http://www.ff.com');

INSERT INTO scarr

(MANDT, CARRID, CARRNAME, CURRCODE, URL)

VALUES ('000', 'EF', 'Easy Flyers', 'EUR',

'http://www.ef.com');

ENDEXEC.

Regards,

Rahul

Re: ABAP native SQL

deepak_dhamat — Fri, 30 Sep 2011 09:38:17 GMT

hi ,

If your are pointing to New database , Please check whether synonyms for those tables are there in the new Oracle database .

You need to maintain Entry of Database Connection in : DBCON table

There migth be OLD DB connection in DBCON table ,so need to create for new database connection or Change

Accordingly .

Synonyms are Generally Pointers which allow access for object which resides somewhere else .

TCode DBCO is used to create a DBCON connection.

Regards

Deepak.