I receive the following error when attempting to create a Response Mass Change with the following criteria:
QG Name: XX
Question Name: YY (Single CHAR variable with default text, only one question specified)
Response, (<XX.YY$F> like '%±%')
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RXC.RXCMCMCS", line 30
ORA-06512: at "RXC.RXCMCCRTCDS, line 1107
ORA-06512: at "RXC.RXCMCCRTCDS, line 1477
Thanks for your reply. The error is received after defining the Mass Change. If either the "Calculate CDS" or "Create CDS" buttons are clicked, the error will appear at the bottom of the window (not pop-up).
It seemed that this problem was going to go away on its own as we ceased to need the mass change. However, it has arisen again.
I have no problem creating a like set of criteria using responses. It is only when the special character is included in the filter that the error appears. It is somewhat odd as the character renders correctly in other areas of the interface, however, I begin to wonder if isn't still fundamentally a characterset issue.
Despite the efficiency of using the special character in the sql statement, I think I will need to simply define the change in another, probably more laborious manner to correct the problem.
This error seems to be is related to the length of the question where you are trying to apply mass changes.
Please check the length of the response which is already entered and the new response. It should be of the less than or equal to the length of the question.
Thanks for the suggestion. I don't think the length of the new response is the issue. My reason for this is that the error occurs before I've even defined this. Also, when I use a successful, but more belabored criteria, I am able to effect the change regardless of the relationship between the original and new values.