Py and SQL
Verde Denim
tdldev at gmail.com
Wed Nov 30 15:30:48 EST 2011
All
I have a sql script that I've included in a simple Py file that gives an
error in the SQL. The problem is that the SQL code executes correctly in a
database IDE environment (in this case ora developer). So, I'm concluding
that I'm doing something amiss in the Py code. Does anyone see why this
code would return a 'missing expression' sql error?
Essentially, the code should start, ask for a privilege, and then collect
the priv, role, and user data. Any input is appreciated.
#!/bin/bash
import time
import cx_Oracle
dbConn = cx_Oracle.connect('juser', 'pass', '1.2.3.4:/orcl:DEDICATED',
cclass = "ABC", purity = cx_Oracle.ATTR_PURITY_SELF)
pStart = time.time()
dbVersion = dbConn.version.split(".")
majVer = dbVersion[0]
print "Oracle Version: %s" %(majVer)
print "Full Version: %s" %(dbConn.version)
dbCursor1 = dbConn.cursor()
dbCursor1.execute('select lpad(' ', 2*level) || c "Privilege, Roles and
Users" from ( select null p, name c from system_privilege_map where name
like upper(\'%&enter_privliege%\') union select granted_role p, grantee c
from dba_role_privs union select privilege p, grantee c from dba_sys_privs)
start with p is null connect by p = prior c')
dbRowResult = dbCursor1.fetchall()
for dbRow in dbRowResult:
print dbRow
dbCursor1.close()
pElapsed = (time.time() - pStart)
print pElapsed, " seconds"
dbConn.close()
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20111130/0efa21db/attachment.html>
More information about the Python-list
mailing list