René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Exception when comparing collections with utp.ut.expect","articleBody":"**Describe the bug**\r\nWhen comparing collections converted to anydata with utp.ut.expect sometimes  we get this error, usually it works correctly.\r\n\r\n**Provide version info**\r\nutPLSQL 3.1.12\r\n\r\n**Information about client software**\r\nnot applicable\r\n\r\n**To Reproduce**\r\n\r\nRun the below script\r\n```sql\r\n\r\n-- type creation\r\n/*\r\ncreate or replace type tp_r_ug_sportsman_invitation_result is object\r\n(\r\n    code              number(18),\r\n    sportsman_name    varchar2(100),\r\n    mobile_phone      varchar2(20),\r\n    err_code          number,\r\n    err_text          varchar2(4000)\r\n);\r\ncreate or replace type tp_t_ug_sportsman_invitation_result is table of tp_r_ug_sportsman_invitation_result;\r\n*/\r\n\r\ndeclare\r\n    --records to compare\r\n    --record 1\r\n    v_sportsman_invitation_result  tp_t_ug_sportsman_invitation_result := tp_t_ug_sportsman_invitation_result\r\n    (\r\n        tp_r_ug_sportsman_invitation_result\r\n        (\r\n            code            =\u003e 1,\r\n            sportsman_name  =\u003e 'sportsman_1',\r\n            mobile_phone    =\u003e '79666666666',\r\n            err_code        =\u003e 1,\r\n            err_text        =\u003e null\r\n        )\r\n    );\r\n\r\n    --record 2\r\n    v_sportsman_invitation_exp  tp_t_ug_sportsman_invitation_result := tp_t_ug_sportsman_invitation_result\r\n    (\r\n        tp_r_ug_sportsman_invitation_result\r\n        (\r\n            code            =\u003e 1,\r\n            sportsman_name  =\u003e 'sportsman_1',\r\n            mobile_phone    =\u003e '79666666666',\r\n            err_code        =\u003e 1,\r\n            err_text        =\u003e null\r\n        )\r\n    );\r\nbegin\r\n    --check rows in collections\r\n    utp.ut.expect(v_sportsman_invitation_result.count, 'count collection')\r\n          .to_equal(v_sportsman_invitation_exp.count);\r\n\r\n    if v_sportsman_invitation_result.count = v_sportsman_invitation_exp.count then\r\n\r\n        for i in 1..v_sportsman_invitation_result.count\r\n        loop\r\n            --check values of each part of a record\r\n            utp.ut.expect(v_sportsman_invitation_result(i).sportsman_name, 'sportsman_name(' || i || ')')\r\n                .to_equal(v_sportsman_invitation_exp(i).sportsman_name);\r\n            utp.ut.expect(v_sportsman_invitation_result(i).mobile_phone, 'mobile_phone(' || i || ')')\r\n                .to_equal(v_sportsman_invitation_exp(i).mobile_phone);\r\n            utp.ut.expect(v_sportsman_invitation_result(i).err_code, 'err_code(' || i || ')')\r\n                .to_equal(v_sportsman_invitation_exp(i).err_code);\r\n        end loop;\r\n\r\n        --compare 2 collections, here we get the exception\r\n\tutp.ut.expect(anydata.convertCollection(v_sportsman_invitation_result), 'Collections equal')\r\n              .to_equal(anydata.convertCollection(v_sportsman_invitation_exp));\r\n\r\n    end if;\r\nend;\r\n```\r\n\r\n**See the exception:**\r\n\r\nORA-06502: PL/SQL: : numeric or value error: character string buffer too small\r\nORA-06512: на  \"UTP.UT_DATA_VALUE_ANYDATA\", line 98\r\nORA-06512: на  \"SYS.DBMS_SQL\", line 2146\r\nORA-06512: на  \"UTP.UT_CURSOR_DETAILS\", line 100\r\nORA-06512: на  \"UTP.UT_DATA_VALUE_ANYDATA\", line 84\r\nORA-06512: на  \"UTP.UT_DATA_VALUE_ANYDATA\", line 114\r\nORA-06512: на  \"UTP.UT\", line 33\r\nORA-06512: на  line 61\r\n\r\n**Expected behavior**\r\n\r\nWe expect to get collections differences.\r\n","author":{"url":"https://github.com/SElfimov","@type":"Person","name":"SElfimov"},"datePublished":"2022-09-28T12:47:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/1235/utPLSQL/issues/1235"}