[Tutor] How can I execute a PL/SQL Procedure directly through
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
db = adodb.NewADOConnection('oci8')
connection_string = makedsn(ip, port, database) <== your values here, of
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Tutor