Pages

SQL to read from BLOB

In some Production  Scenarios you might need to take a decision on some  Property values which are not exposed .

PEGA provides some functions and oracle java classes . Below is the syntax of the sql to read from blob

SELECT pr_read_from_stream('pzInsKey', pzInsKey,pzPVStream)as"PropName" from pc_work


Please make sure your java classes are valid before you run pr_read_from_stream