Godzilla wrote:
> Dear all,
>
> I cannot find a solution for my problem with inserting a blob object
> (>4000 in length) into an ORACLE database via ODBC.
>
>
> I have tried the two ways of inserting the blob object (a zip file):
>
>
> 1)
> fp = open("c:/test/test.zip", "r+b")
> data = fp.read()
> s = odbc.odbc(cs)
> qry = s.cursor()
> qry.execute("Insert into tBlob (data) values ('%s')" %
> data.encode('hex'))
>
>
> return the error: Input String Too Long Limit: 4096
>
>
> 2)
> qry.execute("Insert into tBlob (data) values (?)",
> data.encode('hex'))
>
>
> does not return error, but it does not insert the record correctly.
>
>
> Any help will be fully appreciated...
>
I would certainly recommend that you think about using the cxOracle
package rather than relying on odbc. Most Orcale users do, with evident
satisfaction.
regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://del.icio.us/steve.holden
Recent Ramblings http://holdenweb.blogspot.com
--
http://mail.python.org/mailman/listinfo/python-list
