Stored Procedures changing to invalid unexplainable [message #375023] |
Thu, 19 July 2001 10:41 |
Mike Oakes
Messages: 25 Registered: December 2000
|
Junior Member |
|
|
Hello,
Does anyone know why a stored procedure can change to invalid for no reason. Do schema changes have to be made to the oracle database in order for the procecure to become invalid, or is there another reason that might cause this.
Thanks,
Mike O.
|
|
|
Re: Stored Procedures changing to invalid unexplainable [message #375025 is a reply to message #375023] |
Thu, 19 July 2001 13:29 |
sreek
Messages: 1 Registered: July 2001
|
Junior Member |
|
|
Can you recreate the stored procedure by running the same code used to generate the current object that is becoming invalid?
If the underlying database objects on which the stored procedure was based on have changed, that will make it invalid.
Check the datatypes of the variables used in the stored procedure and the values being passed into it that are used to insert/update tables in the stored proc. Are they compatible with the database table rows/columns?
Recompile the stored procedure.
|
|
|