Oracle stored procedure error with PL/SQL
We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine.
After giving few extra characters above this, it’s giving the error:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "stored procedure name", line 114
ORA-06512: at line 1"
ORA-06502: PL/SQL: numeric or value error
Moderator Note: This is a submitted question.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 14, 2009 4:45 PM
UPDATED:
May 14, 2009 5:19 PM
Answer Wiki:
What is in line 114 of the procedure ?
You could be assigning the parameter value to a local variable, which doesn't have the necessary capacity.
It could be useful to see at least an excerpt of the code.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
