Skip to Main Content
  • Questions

  • SQL Developer execute the sql failed but sqlplus successed

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Q.

Asked: April 10, 2023 - 8:59 am UTC

Last updated: April 11, 2023 - 4:02 am UTC

Version: 22.2.0.173

Viewed 1000+ times

You Asked

the sql script:
select * from table(dbms_workload_repository.awr_report_html(3942554689,1,3770,3771));

using sqlplus execute the sql will success, but i failed when using Oracle SQL developer!
I want to know why please!
DB version:11.2.0.4.0

the error message of SQL developer:
ORA-00904: : invalid identifier
00904. 00000 - "%s: invalid identifier"

and Connor said...

See MOS note

ORA-00904 When Run Any AWR or ASH Reports From SQL Developer (Doc ID 2518648.1)

SQL Developer thinks you have not got sufficient privileges.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.