Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!news-transit.tcx.org.uk!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Wed, 30 Nov 2011 15:37:44 -0500
From: Rod Person <rodperson@rodperson.com>
To: Verde Denim <tdldev@gmail.com>
Subject: Re: Py and SQL
In-Reply-To: <CAB3cKwzodsPqE-sTh6borkxHccgqdbKMToMrR1CpU4_WdqGmfQ@mail.gmail.com>
References: <CAB3cKwzodsPqE-sTh6borkxHccgqdbKMToMrR1CpU4_WdqGmfQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Cc: Python list <python-list@python.org>
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.3171.1322685990.27778.python-list@python.org>
Lines: 54
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:16449

On Wed, 30 Nov 2011 15:30:48 -0500
Verde Denim <tdldev@gmail.com> wrote:

> 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.
>=20
> #!/bin/bash
> import time
> import cx_Oracle
>=20
> dbConn =3D cx_Oracle.connect('juser', 'pass', '1.2.3.4:/orcl:DEDICATED',
>              cclass =3D "ABC", purity =3D cx_Oracle.ATTR_PURITY_SELF)
>=20
> pStart =3D time.time()
>=20
> dbVersion =3D dbConn.version.split(".")
>=20
> majVer =3D dbVersion[0]
>=20
> print "Oracle Version: %s" %(majVer)
> print "Full Version: %s" %(dbConn.version)
>=20
> dbCursor1 =3D 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 =3D
> prior c') dbRowResult =3D dbCursor1.fetchall()
> for dbRow in dbRowResult:
>     print dbRow
>=20

Try changing the wrapping ' ' to " " and the inside double qoutes to
single, like this

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 =3D
prior c")


--=20
Rod
The club is like groceries, and I jus bag a bi@$&!
=AD Santonio Holmes on the Twitter