[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.