topic Re: Native Sql- Execute immediate Statement in Application Development and Automation Discussions

Native Sql- Execute immediate Statement

Former Member — Thu, 10 Apr 2014 13:48:04 GMT

Hello All,

Is it possible to execute SQL statements like :

1.Show parameter compatible.

2.Execute immediate 'alter database rename global_name to TA1.WORLD' into sOut;

with Native SQL.If yes, Can someone provide me examples for the same.

Thanks and Best Regards,

Aman

Former Member — Fri, 11 Apr 2014 13:43:03 GMT

Hi, can you please describe your problem more detail or post some code.

Former Member — Fri, 11 Apr 2014 13:50:17 GMT

Hello Alexander,

I want to execute "Show parameter compatible" statement from ABAP to check whether Oracle Parameter is compatible or not.

Thanks and Best Regards,

Aman

Former Member — Fri, 11 Apr 2014 14:02:03 GMT

🙂

Former Member — Fri, 11 Apr 2014 14:16:15 GMT

Hello Alexander,

I have checked the link given by you. I know this procdure. But i want to know whether is there some way out to do the same from SAP ABAP level .

Thanks and Best Regards,

Aman

Former Member — Fri, 11 Apr 2014 14:35:00 GMT

Sorry. Otherwise I dont have any idea.