Oracle Procedure execution on 2 different databases
Posted on 2007-08-08
I am facing a problem in Oracle.
I am calling a procedure which has 7 parameters : 2 are date type and rest 5 are number types. This is being executed well on test database.
However this call is being failed on Production and throwing : ORA-01858 error.
I drilled further and found that when tracing for this session is trurned ON, it executes. But when it is turned Off for this session, it fails immediately.
Seems to be strange and irrelevant, but switching tracing for the Session ON and OFF os doing trick. However the same piece of code is working good on Test environment without turning session tracing ON and OFF.
the s/w version on both the test and database environment is same.