Details
-
Type: Maintenance
-
Status: Under Review (View Workflow)
-
Resolution: Unresolved
-
Labels:None
-
Old bug number:31768
Description
Summary:
Uniface:
Oracle is used as database.
Read trigger uses maxhits in options part.
Connector options array fetch size and fixed array size are used.
When maxhits is smaller than array fetch size the following error occurs:
ORACLE Driver Error [-62]: Data was truncated on fetch.
Documentation fixed array size:
Use exact array size specified by array fetch size.
Do not increase array size for small records.
So there is a conflict between maxhits and fixed array size
when array fetch size exceeds maxhits.
Environment:
+Uniface Version : 9 / 10
+Operating System : OS independent
+Database : Oracle
Reproduction scenario
1. Oracle used as database for the data.
2. Read trigger uses maxhits in options part: read options "maxhits=1"
3. Oracle connector options array fetch size and fixed array size are used:
usys$ora_params array fetch size 2, fixed array size
4. A retrieve is done
Expected Result
One record retrieved
Actual Result
No record retrieved and in log file the error
ORACLE Driver Error [-62]: Data was truncated on fetch.