Bug with SMALLINT in VARRAY
Posted: Mon 17 Aug 2020 21:04
Hello,
This bug was reported as part of another bug earlier this year. I want to post this again separately so it's easier to find.
To reproduce the problem, first run this script:
Next, try this SQL in a TSmartQuery:
It throws the error: Field 'BPARMS[0]' is of an unknown type
The problem still exists in version 11.2.4. I am using RAD Studio 10.1 Berlin. Compiling in both 32 and 64 bit. Oracle Client and Server are both 19c. Not using Direct mode.
Thank you
John
This bug was reported as part of another bug earlier this year. I want to post this again separately so it's easier to find.
To reproduce the problem, first run this script:
Code: Select all
create or replace type sbool20 as varray(20) of smallint;
create table demo_error (id number not null, bparms sbool20) ;Code: Select all
select * from demo_error;The problem still exists in version 11.2.4. I am using RAD Studio 10.1 Berlin. Compiling in both 32 and 64 bit. Oracle Client and Server are both 19c. Not using Direct mode.
Thank you
John