Blog Archive for April 23, 2010

Output Parameters with cx_Oracle and PL/SQL

April 23, 2010

We were struggling to return an output parameter from a PL/SQL block into a Django application using cx_Oracle. It was very difficult to work out which particular style of bind variables needed to be used.

>>> import cx_Oracle
>>> lDsn = cx_Oracle.makedsn(lDatabaseHost, int(lDatabasePort …