Oracle stored procedure error with PL/SQL

6925 pts.
Tags:
ORA-06512
Oracle stored procedures
PL/SQL
PL/SQL error messages
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following