-
ORA-01722 during Procedure execution
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|