RE: Py and SQL

2011-12-01 Thread Sells, Fred
@python.org [mailto:python-list-bounces+frsells=adventistcare@python.org] On Behalf Of Jerry Hill Sent: Wednesday, November 30, 2011 5:15 PM To: Verde Denim Cc: Python list Subject: Re: Py and SQL On Wed, Nov 30, 2011 at 3:30 PM, Verde Denim wrote: dbCursor1.execute('select lpad(&

Re: Py and SQL

2011-11-30 Thread Jerry Hill
On Wed, Nov 30, 2011 at 3:30 PM, Verde Denim wrote: > 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_priv

Re: Py and SQL

2011-11-30 Thread Rod Person
On Wed, 30 Nov 2011 15:30:48 -0500 Verde Denim 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'

Py and SQL

2011-11-30 Thread Verde Denim
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 c