Question
CIBC
CA
Last activity: 23 Oct 2025 17:32 EDT
Having issues to Fetch Property data from PZPVSTREAM
The pr_read_from_stream function is used to extract the property MessageBody from the Pega BLOB (pzPVStream) . The query was working fine in lower environment. but not working in PROD and throwing the below error
Query: Tried the below query for even single day or for single Message case and received the same error
select Tablename.pr_read_from_stream('Property',pzInsKey, pzPVStream)
Error:
SQL*Plus: Release Proprietary information hidden.0 Production on Wed Sep 24 18:55:16 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning option
The pr_read_from_stream function is used to extract the property MessageBody from the Pega BLOB (pzPVStream) . The query was working fine in lower environment. but not working in PROD and throwing the below error
Query: Tried the below query for even single day or for single Message case and received the same error
select Tablename.pr_read_from_stream('Property',pzInsKey, pzPVStream)
Error:
SQL*Plus: Release Proprietary information hidden.0 Production on Wed Sep 24 18:55:16 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
With the Partitioning option
from pegadata.si_work where MessageType like 'Email' AND pxCreateDateTime >= TO_DATE('2025-09-24','YYYY-MM-DD')
*
ERROR at line 4:
ORA-24345: A Truncation or null fetch error occurred
ERROR:
ORA-24305: Bad bind or define context
and the below
ORA-01002: fetch out of sequence
no rows selected
Elapsed: 00:00:00.10
18:55:16 SQL> Error 45 initializing SQL*Plus
Internal error