Quote Originally Posted by malru
Why the same procedure executed successfully in database "Ora2" not in database "Ora1".What could be the reason for this?
Ora1 and Ora2 are not identical. Look at the definition of tables affected by prepay procedure.