When testing a function that returns a ROWTYPE variable and setting up a basic Outcome test results with the 'records_equal' function generated from the ROWTYPE and saving it, the following errors occur:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "QUESTCODETESTER.QU_REPLACE", line xxx
ORA-06512: at "QUESTCODETESTER.QU_TEMPLATE_XP", line yyy
ORA-06512: at "QUESTCODETESTER.QU_TEMPLATE_XP", line zzz
ORA-06512: at "QUESTCODETESTER.QU_TEST", line lll
ORA-06512: at "QUESTCODETESTER.QU_TEST", line rrr
ORA-06512: at "QUESTCODETESTER.QU_TEST", line nnn
ORA-06512: at "QUESTCODETESTER.QU_TEST", line ppp
ORA-06512: at line j
If setting up other tests for scalars and Ref Cursors it works, however, it is not possible to do this for ROWTYPES.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center