Thanks davey...

I'll check it out but Why the same procedure executed successfully in database "Ora2" not in database "Ora1".What could be the reason for this?