topic Re: sql command editor executing SQL error in Application Development and Automation Discussions

sql command editor executing SQL error

Former Member — Tue, 16 Oct 2012 15:25:08 GMT

Hello team,

when I execute any SQL such as select * from dba_tables; select * from v$instance; in the ST04 sql command editor.

it will show the dump.

I have search the note and message don't find any thing regarding the ABAP program CL_DBA_ACTION_SQL_EDITOR=====CP.

I also don't know why it show the BC-DB-DB6 since currently use the Oracle system.

DB oracle, SAP_BASIS 702, support package 11

Could any one meet this issue before and give me some hint ?

thanks a lot!

Former Member — Tue, 16 Oct 2012 19:54:29 GMT

hello,

Are you trying Native SQL or something else?

The table DBA_TABLES is a structure in SAP and not a transperant table.

best regards,

swanand

Former Member — Wed, 17 Oct 2012 09:15:31 GMT

Hi Lakka,

Thanks for your reply.

After customer give us the SAP_ALL privilege.

Now issue is resovled.

Thanks,

Neil