[Zope] How do I use a Z Oracle Connection in a script?
J. Cone
jcone@g8labs.com
Thu, 12 Jul 2001 19:38:03 +0100
Hello All,
I am trying to save a long raw into a database.
Z SQL Method pastes the parameters into the request, which is
unsatisfactory because this parameter contains stray quotes and unprintable
characters.
I am trying to write a python script, given an oracle connection called
Oracle_database_connection in the same folder.
I currently have AttributeError: cursor on line 4 (really line 3) of:
========================
db=context.Oracle_database_connection;
c=db.cursor()
try:
c.execute('update abs_acct_reference set profile=:p where id = :i',
p=newProfile, i=acctId);
c.commit()
finally:
c.close()
===================
Help?
J. Cone.