Re: [cx-oracle-users] Does cx_Oracle support embedded sql selection?

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/5/23  <Deh...@me...>:
>
> It seems that cx_Oracle will return syntax error if the sql string has the
> embedded sql selection statements.
>
> such as,
> select count(*) from
> (
> select * from employee
> )
>
> Is there any solution for it?

cx_Oracle does not try to parse the SQL statement, it passes it
directly to the Oracle server.
Like sql*plus... except that the semicolon at the end must be removed!
Do you have an example of code that fails?

-- 
Amaury Forgeot d'Arc