Retail Point-of-Service Solutions (MOSC)

MOSC Banner

How to open Blob receipt_data field from trn_receipt_data table

Hi,


I noticed that after performing a sale xstore stores the information of the receipt into the receipt_data field from trn_receipt_data table, which is after used by Electronic Journal module to reprint the receipts.

I am facing a problem where xstore is not reprinting the appropriate receipt for a specific transaction.

Before trying to see if the problem is in xstore I wanted to see what wash actually saved on that field, but the sql development does not show the detail itsel, it only shows (Blob).

Looking into internet I found that is possible to download the file that is stored there and after doing it I got a blob file without any extension (however after opening it with a text editor I can notice that this is a binary file).

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