Getting xml data from trn_poslog_data poslog_bytes column in Xstore V20
Hi all
In Xstore V17, tabled TRN_POSLOG_DATA contains column POSLOG_DATA of type CLOB, and the data in the CLOB is an XML string.
In V20 the xml data is now inserted into the same table but column poslog_bytes and the column is of type BLOB.
Has anyone here experience with extracting the data from TRN_POSLOG_DATA and converting the binary object back to a string?
I tried the normal Oracle sql methods for converting data but the string is unreadable, eg
select utl_raw.cast_to_varchar2(dbms_lob.substr(poslog_bytes)) from trn_poslog_data where rowid = 'AAAariAAIAAAAorAAA';