Topic: SQL*Plus and PL/SQL >> Create or Replace Directory throwing Table or View Doesnot exists
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Create or Replace Directory throwing Table or View Doesnot exists |
| Roopa |
Posted: Apr 05, 2005 09:52:45 AM |
Total Post: 3
Joined: Apr, 2005
|
Hi all,
I have a PL/SQL code which has "create or replace directory ..." statement in it. C# is used for frontend.
When I call the PL/SQL from C# front end , Oracle throws back the exception saying "Table or View doesnot exist" at the line "create or replace directory ...".
The stack trace is
ORA-00942: table or view does not exist
ORA-06512: at \"SYS.DBMS_SYS_SQL\", line 824
ORA-06512: at \"SYS.DBMS_SQL\", line 32
ORA-06512: at \"myPackage\", line 553 (Where "create or replace directory ..." is there")
I have all the permissions set for the sid.
The Platform I am using is Unix and version of Oracle is 8i.
Can anyone help me what might be the reasons for such an exception from Oracle. |
|
|
 Vigyan |
| Posted: Apr 05, 2005 01:22:16 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Are you sure, the user that is connecting to the database has EXECUTE privileges on DBMS_SQL?
You can also try SYS.DBMS_SQL in your PL/SQL code if privileges are there.
Vigyan
|
|
|
|
|
| Roopa |
| Posted: Apr 06, 2005 01:01:17 AM | |
|
Total Post: 3
Joined: Apr, 2005
|
Hi,
Ya the user connecting to the database has all the priviliges granted. It has EXECUTE on DBMS_SQL. But the error occurs some where while executing the package.
The trace file stops at the point
select grantee#,privilege#,nvl(col#,0),max(nvl(option$,0))
from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
Thanks and Regards,
Roopa
|
|
|
|
|
| Vigyan |
| Posted: Apr 07, 2005 02:45:10 PM | |
|
Total Post: 386
Joined: May, 2001
|
ok..
Two more things to check.
1. Can you run this pl/sql code from SQL*Plus. Connect as the same user.
2. Does this code is in the procedure/package.. if not, try to put in.
Let me know how that goes?
Vigyan
|
|
|
|
|
| Roopa |
| Posted: Apr 08, 2005 12:57:08 AM | |
|
Total Post: 3
Joined: Apr, 2005
|
Ya I have run the code from SQL+ with the same user, It executes. I have run the "create or replace .." sql statement as well within the pacakge , It works fine.
Thanks & Regards,
Roopa
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 856 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 281 |
| neeraj sharma | 254 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
