How to display a BLOB/CLOB in Oracle Forms?

[oracle70]

How to display a BLOB/CLOB in Forms?

Hi,

We have a problem like this: There is a text file containg data on a conversation done by Forex dealers. We want to store this in an Oracle table and and display using Oracle Forms. I tried using OLE db, ACtive X as the data type for the filed but it did not work. Would be very greatful for any suggestions.

Regards,
Francis.

This is what the conversation looks like:

<STX><FS>340<US>AA<GS>CENS#9240C<US>504<US>0<RS>548<US>TO CENS CENTRAL BK SRI LANKA * 0959GMT 030903 */1738 CNV
Our terminal : CENS Our user : NWGRD Nanayakkara
# RAJA> DLR/YEN FOR ONE PL
VEDITHRI> 09/17
# SELL DLRS
TO CONFIRM 1 MIO AGREED AT 116.09 I BUY USD
# MY YEN TO BTM TOKYO AC NO 0012500354 PL
MY USD TO FED RESERVE NY, NEW YORK
# AGREED

# #INTERRUPT#
#
#INTERRUPT#

#END REMOTE#
^ ##ENDED AT 10:01 GMT##
^ ## TKT EDIT OF CNV 1738 BY DN 1001GMT 03SEP2003
^ STATUS CONFIRMED
^ ##ENDED AT 10:01 GMT##

( 52 CHARS)





<FS><ETX>>

 

[sem]

If your files are less than 8K you may use ordinary multiline text item.

Regards, Dima

 

[oracle70]

Actually I tried using a text item. But what I get is just garbage. The conversation I have specified has some special characters and should be treated as a binary file and NOT a text file.

 

[sem]

How can you display BINARY data??? Are they really special or just Japanese letters?

Regards, Dima

 

[SirCharles]

I believe you'll have to modify your forms trigger to do a to_char(clob_field), check for length > 4000 chars and loop on the value with catenation till you get it all to display.