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

Jul 19 '05 #1

Subscribe Post Reply

8617

by: freak | last post by:

hi i have problems reading an oracle(9i) clob from a php-script with the MDB-class from pear. the table files has 3 fields: id integer document clob picture clob

PHP

CLOB.createTemporary throws ClassCastException - fyi

by: Chris | last post by:

I use websphere connection pooling and had a failure attempting a CLOB.createTemporary. tempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION); Here's an excerpt of the exception...

Oracle Database

Insert CLOB / BLOB

by: Nina via DBMonster.com | last post by:

Hi, I'm trying to insert a clob / blob from the local file system into a basic table. This can be quite easily accomplished in Oracle but I have not found any wquivalent way on how to do this in...

DB2 Database

Using C# to insert blob into Oracle

by: Chris Fink | last post by:

I have setup an Oracle table which contains a blob field. How do I insert data into this field using C# and ADO.net?

C# / C Sharp

DataType for BLOB

by: C Glenn | last post by:

What DataType should I use for a field that is BLOB SUBTYPE TEXT on the backend? I've tried String and Char. I'm getting a runtime error telling me that the SourceColumn is a Char. Thanks.

C# / C Sharp

using clob in where clause

by: gupta.harika | last post by:

Hi everyone, I am a developer working on php with oracle as backend. I am facing a problem related with the CLOB data. The problem is as follows My application uses a table which contains Clob...

PHP

Bulk Load BLOB using DB2 CLI

by: msc.batra | last post by:

I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which are the possible ways to do it? Any help...

DB2 Database

Create report that displays Oracle CLOB data correctly?

by: egarobar | last post by:

I am using Access 2003 (on WinXP) to read from an Oracle db, where there is a table with a CLOB which is a variable-size text field. In the 'linked table' which is created in the Tables panel of...