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
_______________________________________________
Tutor maillist - [email protected]
http://mail.python.org/mailman/listinfo/tutor
