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!

Sys Tables In Stored Procedure

Ahamed RafeequeJan 31 2010 — edited Jan 31 2010
How can I use Sys Table in Stored Procedure.

I want to use DBA_TAB_COLOUMNS, in stored procedure.

When I used this table in stored procedure I got an error

ORA - 00942 Table or View Does not exists.

Thanks,
Ahamed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2010
Added on Jan 31 2010
#in, #procedure
5 comments
1,436 views