[Baypiggies] Reading file and inserting BLOB in oracle database.
ramkarthik at gmail.com
Thu Jul 27 00:28:15 CEST 2006
I've used cx_Oracle before and it seemed to be do the job well for me
(haven't done anything with LOBs). Documentation seems to suggest that it is
On 7/26/06, Shannon -jj Behrens <jjinux at gmail.com> wrote:
> I've used mxODBC with good results.
> Prasanna, I assume you've already checked out
> Best Regards,
> On 7/26/06, Chris Clark <Chris.Clark at ingres.com> wrote:
> > Prasanna Rajagopal wrote:
> > > Hi
> > > Thank you for your reply. Is there something similar to "ingresdbi"
> > > Oracle database, in other words, which python oracle driver I should
> > > use?
> > I have no idea, I've seen at least one Oracle specific driver in my
> > travels but don't recall the name. I suspect google is your best friend
> > for that.
> > There are a couple of ODBC based ones, one with a dual license (mxODBC)
> > and there is a free (MIT license) one called PyODBC
> > http://pyodbc.sourceforge.net/, I know they have lob support as we've
> > had some discussions with them.
> > One slightly odd option would be to use the ingresdbi driver against
> > Oracle :-S ingresdbi is based on ODBC (written in C), it probably won't
> > work out of the box but it wouldn't take much work to get it to work
> > with multiple back ends (we accept code contributions :-)).
> > > I tried ADODB for python, but I felt it does not offer much
> > > support for BLOB handling. I am new to Python, so I might be wrong.
> > >
> > I've never used it (I've heard good things) and I don't know about the
> > lob support it has.
> > > I tried the following:
> > > ..... snip'ed
> > > sql = "insert into blob_test (blobtestid, blob_field) values
> > > (101,empty_blob())"
> > >
> > > oraCur = oraConn.Execute(sql)
> > >
> > > oraConn.UpdateBlob('BLOB_TEST','BLOB_FIELD', data, 'BLOBTESTID = 101')
> > >
> > > This does not work.
> > >
> > This isn't following the DBI spec (it is an extension) so whilst can
> > guess what it is doing I don't _know_ what this is doing, the method
> > name certainly does imply there is lob support. You may want to try
> > emailing the author of the driver you are using, or even google for the
> > method name.
> > Good luck,
> > Chris
> > _______________________________________________
> > Baypiggies mailing list
> > Baypiggies at python.org
> > http://mail.python.org/mailman/listinfo/baypiggies
> Baypiggies mailing list
> Baypiggies at python.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Baypiggies