| Procedure status is Invalid. [message #55294] |
Thu, 16 January 2003 04:51  |
V
Messages: 12
Registered: October 2001
|
Junior Member |
|
|
Hello all,
I have created my database Script. When i execute the script, it will say Some procedrues are created with errors , and later when i simply say
"Alter Procedure procedurename Compile;"
then it will be fine..
so what i did was i kept Alter statements for all the procedures at the end of the script file..
Still after the script is executed, it will again show errors. now again i need to compile it ..
What is this ? how do i resolve this.. I need to pack my database script along with my product.. Please help me resolving this..
My database version is Oracle 8.1.7
Its Very urgent.. Please help me..
V
|
|
|
|
| Re: Procedure status is Invalid. [message #55298 is a reply to message #55294] |
Thu, 16 January 2003 06:18  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
are u using dynamic sql to create or alter the procedures?
what ever it is,
try to grant all the required privs explicitly to user.
any privs granted via role WILL NOT BE SEEN BY PL/SQL.
so,
when u do something in pl/sql it fails
But in
in sql*plus it works
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
