Retail Point-of-Service Solutions (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center