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 -> Re: LOBs and Oracle

Re: LOBs and Oracle

From: Alex <tomiro_at_web.de>
Date: Wed, 27 Nov 2002 09:10:45 +0100
Message-ID: <3DE47E05.4030508@web.de>


Thank you very very much!

I'll try it immedieatly. Thanks again.
Alexander Pfeifer

Mike Ault wrote:

> At www.robonerd.com I have an example graphics applicaiton using JAVA
> to display a graphic image that has been stored in Oracle, it is
> located in the catalog under the monographs area. It shows how to use
> DBMS_LOB calls in JAVA to get the blob displayed and includes all the
> code. Using various JAVA stream classes you can do streaming content
> such as video and mp3. Technet also has many examples
> (technet.oracle.com).
> 
> Mike Ault
> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<arsqpn$ec2$1_at_babylon.agtel.net>...
> 

>>Hmm... First of all, you *can* use select statements to retrieve LOBs.
>>And the way you want to "use" them should dictate the way you
>>retrieve them. In JDBC, you can access LOBs as streams or you
>>can use Oracle DBMS_LOB package calls to retrieve them in chunks
>>of up to 32K in size. Not sure why you are getting errors with ODBC,
>>but I am confident that you can access LOBs with ODBC and OLE DB,
>>too. Can you be more specific as of error message ODBC driver returns
>>(note, that this may actually be Access limitation, not ODBC.) You say
>>that your sqlj code does not compile - can you quote it and error
>>messages reported by sqlj preprocessor? Without these details our
>>crystal balls will most certainly fail to reveal the true nature of your
>>problem...
>>
>>--
>>Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
>>Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
>>All opinions are mine and do not necessarily go in line with those of my employer.
>>
>>
>>"Alex" <tomiro_at_web.de> wrote in message news:3DE0EFCC.60306_at_web.de...
>>
>>>Hi,
>>>
>>>I'm new at this group and have a problem with Oracle (9.2i).
>>>I want to store multimedia data in my table. I use blob, clob and
>>>bfiles. I can put it into the database and can delete it from the
>>>tables. But I find no way to "use" the lob. (view a picture, hear a mp3,
>>>and so on). I know that I cannot use the select statement, but odbc
>>>shows only errors in MS Access (errorr with the OLE-Server) and JDBC
>>>does not comile the sqlj file.
>>>
>>>Maybe there exist an easier way to examint the data of lob.
>>>
>>>Has anyone else experienced with the same difficulties???
>>>
>>>Thank you very much for your help in advance!
>>>
>>>Alexander Pfeifer
>>>
>>
Received on Wed Nov 27 2002 - 02:10:45 CST

Original text of this message

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