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 Tue Nov 26 2002 - 07:57:59 CST
