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: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 25 Nov 2002 12:31:31 +0300
Message-ID: <arsqpn$ec2$1@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 Mon Nov 25 2002 - 03:31:31 CST

Original text of this message

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