| Dynamyic SQL [message #370024] |
Thu, 30 November 2000 11:14  |
Salman Khan
Messages: 51
Registered: September 2000
|
Member |
|
|
Hi,
I have create a procedure and iam using dynamic sql in it, now iam getting an error when iam try to pick some information from data dicitionary (v$ tables). procedure created sucessfully but when i tried to run its show this error
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYSTEM.SP_DB_TABLE", line 26.
I think dynamic sql wont allowed to use v$ tables in pl/sql.
is there anyway i can use it in pl/sql?
Thanks in Advance
Salman Khan
|
|
|
|
| Re: Dynamyic SQL [message #370174 is a reply to message #370024] |
Wed, 27 December 2000 11:14  |
A. Roy
Messages: 3
Registered: December 2000
|
Junior Member |
|
|
Hi Salman,
The first thing I'd do is check if the account running this program has the right privileges to view this table. It sounds like a privilege problem to me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
