When multiple outcomes are expressions, the code fails to compile or shows error 'ORA-06502' (4240461)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

When multiple outcomes are expressions, the code fails to compile or shows error 'ORA-06502'
Description

When multiple outcomes are expressions, and they are of different types (number, string, date), the resulting generated code either fails to compile or gets a runtime error: 'ORA-06502 - PL/SQL: numeric or value error'.
Cause

This happens because the variables for the expressions are all of the same name, and declared just once, instead of once for each outcome.
Resolution

WORKAROUND:
None.

STATUS:
Waiting for fix in a future release of Quest Code Tester for Oracle
Defect ID

ST 63725

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title