Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help! -- how to store and retrieve data from LONG RAW column(Oracle V 7.3)?

Help! -- how to store and retrieve data from LONG RAW column(Oracle V 7.3)?

From: zjia <zjia_at_hawaii.edu>
Date: 1997/08/23
Message-ID: <01bcaf65$526d6530$8d0aab80@tanami>#1/1

Hi,

i am newbie to OPO and am frustrated about the "long raw" column. i really needs your help here.

It is said that we can store 2GB data into "long raw" column. But how can i achieve that???

My experience with the "Long Raw" as follows:

1.) i can not use "browsing the table"(OPO) / using "insert" (SQL) to store data to the "Long raw" column

2. ) it seems working using the OLE control to store data. ( in the OLE control, calling "OLEInsertObject" to read data from file) But how can i know whether it stores data correctly and how can i retrieve data from that column?

      i tried to use "WriteColToFile" and it produces one file that can not be read by server application. Maybe due to four-byte prefix?

Oh, i am really lost. So difficult to manipulate the "long raw" column. Maybe somebody has already asked about such questions. But i can not find any information in the newsgroup.  

i highly appreciate your help. Please reply.

Thanks, Received on Sat Aug 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US