| Invalid database objects [message #53226] |
Thu, 05 September 2002 02:58  |
Srinivas
Messages: 138
Registered: June 2000
|
Senior Member |
|
|
we r using oracle 8.1.7 database, frequently some of the database objects getting invalid - procedures & triggers after recompiling same thing repeating
what will be the reason?
can anyone help me!!
|
|
|
|
| Re: Invalid database objects [message #53227 is a reply to message #53226] |
Thu, 05 September 2002 03:03  |
Keith
Messages: 88
Registered: March 2000
|
Member |
|
|
Could be object definitions changing e.g. tables which are referenced by the procedures, triggers. This will invalidate code......
Any dynamic SQL (or rogue users :-)) who could be doing this?
|
|
|
|
| Re: Invalid database objects [message #53229 is a reply to message #53226] |
Thu, 05 September 2002 05:00 |
RameshDB
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
Hi,
One of the reasons that could be possible is that, the depending table be be altered. i.e. If the procedure is accessing a table, then any DDL changes to this table will make the procedure invalid.
Thanks.
Regards,
Ramesh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
