Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' when running Toad generated Function statement in Script Runner (4242862)
'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' when running Toad generated Function statement in Script Runner
Description
When you right-click a Function in the Schema Browser, click Execute, and then in the Set Parameters window that shows up, if you press the 'Run in Script Runner' button, the following error shows:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 29
It seems to be due to the line which is generated at the end:
:1 := l_RetVal; If this line is commented out, or if l_RetVal is an integer, there is no error
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.