Oracle jdbc sql select for update in python

loial jldunn2000 at gmail.com
Wed Nov 17 10:41:54 EST 2010


I want to do a select from...for update in python, update the selected
row and then commit;

However cannot seem to get it to work...the update statement seems to
be waiting because the row is locked. Presumably oracle thinks the
update is another transaction.

How can I get this to work? What statements do I need to ensure Oracle
treats this as one transaction?







More information about the Python-list mailing list