Hi Freinds,
We are facing a very strange problem. Our system consists of UNIX batches which call the PLSQL procedures to execute the validations on the database.
We have a list of plsql procedure names stored in a table with a column having a sequence in which they have to be executed.
The problem is that one of the procedure is working very differently. Some times when we execute the batch it gives the error on one record, and if we execute it again it processes the record successfully. We have recently upgraded to oracle 10g dont know if this is related to that, but its causing lots of confusion.
Has anyone experienced such a problem when a simple update behaves differently for the same data on different times.
plz help