[Tutor] How can I execute a PL/SQL Procedure directly through

Greg Lindstrom gslindstrom at gmail.com
Mon Jul 30 14:05:38 CEST 2007


My Oracle connection is set up using the adodb module (
http://adodb.sourceforge.net/).  I don't remember why we set it up that
way...we haven't touched this part of our code for almost 2 years!.

from cx_Oracle import makedsn
import adodb

db = adodb.NewADOConnection('oci8')
connection_string = makedsn(ip, port, database)   <== your values here, of
course
db.Connect(connection _string, username, password)  <== and here, too

query = "SELECT name_of_pgSQL_routine(%(argument1)s, %(argument2)s)"
results = db.execute(query, locals())

and go from there.  Let me know if yo have other questions.

HTH,

--greg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20070730/305a25c4/attachment.htm 


More information about the Tutor mailing list