Python Oracle 10g odbc blob insertion problem

Godzilla godzillaismad at gmail.com
Thu Mar 22 18:25:25 EDT 2007


On Mar 23, 4:38 am, Dennis Lee Bieber <wlfr... at ix.netcom.com> wrote:
> On 22 Mar 2007 05:36:46 -0700, "Godzilla" <godzillais... at gmail.com>
> declaimed the following in comp.lang.python:
>
> > Steve, I think I've tried what you have suggested without any luck as
> > well... The statement works fine, but what inserted is not correct...
> > it seems like only the symbol '?' was inserted into the blob field...
>
>         You didn't have a set of 's around the ?, did you? Parameter
> substitution will add needed quotes on its own rather than you having to
> put in quotes.
>
>         Also, though I find no documentation on it, odbc module cursors have
> setinputsizes() and setoutputsizes() methods -- perhaps that could
> change things... OTOH: the db-api 1.0 PEP (which is, it seems, what odbc
> module follows) says they may be do-nothing methods.
> --
>         Wulfraed        Dennis Lee Bieber               KD6MOG
>         wlfr... at ix.netcom.com             wulfr... at bestiaria.com
>                 HTTP://wlfraed.home.netcom.com/
>         (Bestiaria Support Staff:               web-a... at bestiaria.com)
>                 HTTP://www.bestiaria.com/

Gidday Dennis,

Thank you for your suggestion. I have found those two functions you
mentioned, and there were not much or no documentation for those
functions... I used both function and they pretty much do nothing for
me...




More information about the Python-list mailing list