Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
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()

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
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 =

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
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 =

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Paul Boddie
On 22 Mar, 10:21, Godzilla [EMAIL PROTECTED] wrote: I cannot find a solution for my problem with inserting a blob object (4000 in length) into an ORACLE database via ODBC. This brings back happy memories with Oracle 9i and JDBC. I have tried the two ways of inserting the blob object (a zip

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
On Mar 22, 10:56 pm, Steve Holden [EMAIL PROTECTED] wrote: 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 =

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
On Mar 23, 4:38 am, Dennis Lee Bieber [EMAIL PROTECTED] wrote: On 22 Mar 2007 05:36:46 -0700, Godzilla [EMAIL PROTECTED] 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

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
On Mar 23, 4:38 am, Dennis Lee Bieber [EMAIL PROTECTED] wrote: On 22 Mar 2007 05:36:46 -0700, Godzilla [EMAIL PROTECTED] 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

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
Godzilla wrote: On Mar 23, 4:38 am, Dennis Lee Bieber [EMAIL PROTECTED] wrote: On 22 Mar 2007 05:36:46 -0700, Godzilla [EMAIL PROTECTED] 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

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
On Mar 23, 9:50 am, Steve Holden [EMAIL PROTECTED] wrote: Godzilla wrote: On Mar 23, 4:38 am, Dennis Lee Bieber [EMAIL PROTECTED] wrote: On 22 Mar 2007 05:36:46 -0700, Godzilla [EMAIL PROTECTED] declaimed the following in comp.lang.python: Steve, I think I've tried what you have