How to display a BLOB/CLOB in Oracle 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##  ( 52CHARS) <FS><ETX>>

--
Posted via http://dbforums.com