cx_Oracle execute procedure

Poppy znfmail-pythonlang at yahoo.com
Wed Mar 19 16:35:14 CET 2008


Thanks Jerry and Diez. The first two replies I found answered my noob 
question.


"Jerry Hill" <malaclypse2 at gmail.com> wrote in message 
news:mailman.2148.1205940209.9267.python-list at python.org...
> On Wed, Mar 19, 2008 at 11:03 AM, Poppy <znfmail-pythonlang at yahoo.com> 
> wrote:
>> I've been working on the code below and and executes silently, no
>>  complaints, however the end result should be a record in my table and 
>> it's
>>  not added. The procedure works with the passed credentials using SQLPlus 
>> or
>>  SQL Developer clients. However I'm not sure if I'm constructing my 
>> python
>>  code correctly to interact with Oracle.
> ...
>>  connection.commit
>>  cur.close
>>  connection.close
>
> You have to actually call these methods:
> connection.commit()
> cur.close()
> connection.close()
>
> Without the parentheses, you're just getting a reference to the
> methods and immediately discarding them.
>
> -- 
> Jerry 





More information about the Python-list mailing list