Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
invalid procedures
- Thread starter mkey
- Start date
I'm not sure what your situation is. Are you saying that the tables the procedure references were empty? If that is what you mean, then the answer is "yes". However, that would not prevent the procedure from compiling.
If the tables used to have data but now they don't, the question becomes "what happened to the data?". And about the only answer I know of is that a procedure that can't compile didn't do it.
Please expand on your problem.
If the tables used to have data but now they don't, the question becomes "what happened to the data?". And about the only answer I know of is that a procedure that can't compile didn't do it.
Please expand on your problem.
- Thread starter
- #3
HI Carp,
Recently we noticed some of our data from certain tables were missing. These data were existed before. I do not know what exactly the procedure originally written for. But I'm pretty sure that the procedures was not created to delete data. The question I need to find answer for is that is it possible to loose data in Oracle 8i when you have invalid objects ie. an invalid procedure that access some tables to do some sort of sql query?
I do not know whether I explained my question clearly but, I am not concerned about the invalid procedure. Rather I need to find out if an invalid procedure would corrupt the data to some extent?
thxs!
Recently we noticed some of our data from certain tables were missing. These data were existed before. I do not know what exactly the procedure originally written for. But I'm pretty sure that the procedures was not created to delete data. The question I need to find answer for is that is it possible to loose data in Oracle 8i when you have invalid objects ie. an invalid procedure that access some tables to do some sort of sql query?
I do not know whether I explained my question clearly but, I am not concerned about the invalid procedure. Rather I need to find out if an invalid procedure would corrupt the data to some extent?
thxs!
Invalid procedures do not corrupt data.
try to compile the proc to see what the error is. I have seen procecures become invalid under 8.1.5 for no apparent reasons. The solution was to recompile them.
If you have some tables missing data, I would look at the code. Too bad I.T. is not cash business
Luc Foata
Unix sysadmin, Oracle DBA
try to compile the proc to see what the error is. I have seen procecures become invalid under 8.1.5 for no apparent reasons. The solution was to recompile them.
If you have some tables missing data, I would look at the code. Too bad I.T. is not cash business
Luc Foata
Unix sysadmin, Oracle DBA
Abhivyakti
Technical User
- Dec 1, 2001
- 22
hi mkey,
The procedure becomes invalid only when
1) the object on which it is dependet is changed. for example proc1 is gving a call to proc2 within proc1's body, and proc2 is either recompiled or deleted. If proc2 is recompiled, adn proc1 too is recompiled then proc1 wont be invalid.
2) The procedure is dpenedent on remote object whichis not available right now...for say...some missing network connection.
Apart from this, as far as i think, the invalid doesnt currupt procedure data. AT themost what could have happend is that hte table DML stmts might have changed it.
or may be after entering data it has not been committed... coz it happend once in our institute that the students created tables, inserted data and next day nothin was available except for hte table structure. So, we wondered as to what happend to the autocommit mode.Anywy, that is a diff situation
The procedure becomes invalid only when
1) the object on which it is dependet is changed. for example proc1 is gving a call to proc2 within proc1's body, and proc2 is either recompiled or deleted. If proc2 is recompiled, adn proc1 too is recompiled then proc1 wont be invalid.
2) The procedure is dpenedent on remote object whichis not available right now...for say...some missing network connection.
Apart from this, as far as i think, the invalid doesnt currupt procedure data. AT themost what could have happend is that hte table DML stmts might have changed it.
or may be after entering data it has not been committed... coz it happend once in our institute that the students created tables, inserted data and next day nothin was available except for hte table structure. So, we wondered as to what happend to the autocommit mode.Anywy, that is a diff situation
- Status
Similar threads
- Locked
- Question