A user reported a problem in which their program, which seemed to execute just fine, would raise the
ORA-01460: unimplemented or unreasonable conversion requested
error when run within Code Tester.
I tracked down the problem to the CHAR (fixed length) argument of the program.
Code Tester generates a local variable like this to hold the input value:
Inside the program, this argument is referenced inside a query:
SELECT * into l_rec FROM table WHERE col = l_arg_in;
and it looks like inside SQL (within PL/SQL), it cannot work with a CHAR value that is greater than 4000 in length. This same problem does NOT occur with VARCHAR2.
1 Open the Test Editor for this program.
2 Navigate to the program being tested, then to the Test Elements section.
3 Click on the CHAR argument.
4 Change the “Datatype as Declare” field from CHAR(32767) to CHAR(4000).
Then the problem should go away.