Question
AIG
US
Last activity: 24 Apr 2019 21:18 EDT
buffer size is long enough to store the returned data
while reading content of blob property using pr_read_from_stream('.pyAxx', pzInsKey, pzPVStream) , I am seeing below message for property which has bif string
and its throwing an error as ORA-24345: A Truncation or null fetch error occurred
24345. 00000 - "A Truncation or null fetch error occurred"
*Cause: A truncation or a null fetch error"
*Action: Please ensure that the buffer size is long enough to
store the returned data.
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
IN
Hi ,
Please check for the max data length of the column value which your fetching from the database in the program and match it to the variable length u have defined in the code.
The variable u have set in your program is not able to hold the data which u r fetching from the DB.
There could be a mismatch in the data length definition which u have given in your program block and the actual data length stored in the DB.This could be the reason i guess.
Please let us know the Pega Version you are using.
For Pega 7.2 version below PDN link will be helpful.
Hi ,
Please check for the max data length of the column value which your fetching from the database in the program and match it to the variable length u have defined in the code.
The variable u have set in your program is not able to hold the data which u r fetching from the DB.
There could be a mismatch in the data length definition which u have given in your program block and the actual data length stored in the DB.This could be the reason i guess.
Please let us know the Pega Version you are using.
For Pega 7.2 version below PDN link will be helpful.
For Pega 7.1.7:
Thank You,