How to display a BLOB/CLOB in Oracle Forms?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • channa_s

    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#924 0C<US>504<US>0< RS>548<US>TO CENS CENTRAL
    BK SRI LANKA * 0959GMT 030903 */1738 CNV

    Our terminal : CENS Our user : NWGRD Nanayakkara

    # RAJADLR/YEN FOR ONE PL

    VEDITHRI09/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
Working...