Hi all,
1) this are the *correct* quotation marks:
strUpdate = " UPDATE table SET firstname = 'JOSEPH' WHERE lastname = 'SMITH' "
because SQL uses single quotation marks for character strings in column values.
Double quotation marks are used to quote a column name when the column name
is define
:[EMAIL PROTECTED]
> Sent: Tuesday, March 29, 2005 3:23 PM
> To: Williams, Thomas
> Cc: tutor@python.org
> Subject: Re: [Tutor] updating Oracle tables via python
>
> Is that all the code? It's not going to be giving you any feedback.
> Chuck a few print commands in it.
>
Is that all the code? It's not going to be giving you any feedback.
Chuck a few print commands in it.
i.e.
connection = cx_Oracle.connect("db/[EMAIL PROTECTED]")
cursor = connection.cursor()
print "Cursor created"
strUpdate = " UPDATE table SET firstname = 'JOSEPH' WHERE lastname = 'SMITH' "
Greetings,
I am attempting to update an Oracle table
using python. When I execute the code, the python script appears to hang,
in that nothing else happens.
As always, any assistance you can provide
will be appreciated.
Code:
connection = cx_Oracle.connect("db/[EMAIL PROTECTED
