Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$database can not access in function

818226May 19 2011 — edited May 19 2011
Hi,

OS: XP
DB: oracle 10g R1

I log on to the database by sqlplus using "system" user.
I can access the v$database using "select" statement.

But when I create a function, which includes a "select" statement accessing v$database, the "PL/SQL: ORA-00942: table or view does not exist" error appears.
Usually, this error is caused by insufficient privilege.

What I am wondering is why "select" alone is Ok while in function it fails.

Please give me some ideas about this.

Thanks.
This post has been answered by Saubhik on May 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2011
Added on May 19 2011
#pl-sql, #plsql
5 comments
1,245 views