Hi,

There is a procedure in my database(Ora1),It's getting compiled
successfully,when i execute it,it gives the following error:

begin prepay('Y','601','Y','G','01/APR/2007','30/APR/2007','601'); end;

ORA-01722: invalid number
ORA-06512: at "PREPAY", line 466
ORA-06512: at line 1

There is another database(Ora2) in the same server,I created this procedue
in this database & tried to execute it.In this database(Ora2),this procedure
executed successfully.

Why this procedure execution gives error in database "Ora1",why it's not
giving error in database "Ora2"?

Kindly give ur suggesstion to rectify this error so that this procedure can
be executed successfully in database "Ora1".

Both the databases are running under same version(9.2.0.8)

Thanks...