topic Re: pbm in EXEC SQL ..ENDEXEC native SQL not working in 4.6c in Application Development and Automation Discussions

pbm in EXEC SQL ..ENDEXEC native SQL not working in 4.6c

Former Member — Tue, 08 Dec 2009 06:53:54 GMT

Hello all

I have a situation...I needed to create a FM 'GET_DB_ORA_RELEASE' which is not present in 4.6c but its there in ECC6.

So i copied the code in FM from ECC6 to 4.6c as it is .. using Access key... But when i execute the same ., the native sql query used is not getting executed in 4.6C ...because of which FM is not working.

Code is as below

PERFORM db_connect USING con_name.

EXEC SQL.

select version FROM v$instance INTO :string

ENDEXEC.

Here when i execute FM in ECC6 ..control goes inside EXEC SQL ... ENDEXEC block ..and executed the select query BUT

when i run the FM in 4.6C ..control DOESNOT go inside EXEC SQL ...ENDEXEC block...

Please provide ur valuable inputs..

Thanks & Regards

Nilesh

Re: pbm in EXEC SQL ..ENDEXEC native SQL not working in 4.6c

Kanagaraja_L — Tue, 08 Dec 2009 12:34:07 GMT

Check the DB connection is available in Table DBCON, If not make a connection to the External DB (Check with your BASIS).

Kanagaraja L

Re: pbm in EXEC SQL ..ENDEXEC native SQL not working in 4.6c

Former Member — Wed, 16 Dec 2009 09:16:47 GMT

i saw there was no entry in DBCON table ..how can we add entry in that table ?