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

[Former Member]

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

[Kanagaraja_L]

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

Kanagaraja L

[Former Member]

Hi

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