In R11, When You Run The Procedure, ORA-6502 Occurred(PSD: 606884)
Last updated on SEPTEMBER 06, 2012
Applies to:PL/SQL - Version 188.8.131.52 and later
Information in this document applies to any platform.
When trying to access cursor parameter of type CHAR (no size mentioned) in a PL/SQL block, it may return a very large value compared to what was assigned to
them and throw a 6502 "PL/SQL: numeric or value error" error when attempted to assign to another variable.
A SQL trace reveals that these parameters are getting modified during runtime.
The trace indicates that a lot of spaces are appended to the end of the string.
For example: A cursor parameter which is of type CHAR was passed a value of '20120331' while opening the cursor and it is getting modified to:
Observe the empty spaces appended to the end of the string.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms