How to display a BLOB/CLOB in Oracle Forms?

[channa_s]

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>54 8<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