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
