[DB-SIG] See the bind query statment

[Matthew T. Kromer]

Titu Kim wrote:

>Hi there,
>   I have a query that is executed using
>cursor.execute(query, param1,param2....). How can i
>see the substituted query that is presented to
>database? I am using DCOracle2 module for db
>connection. Please enlight me on this issue. Any
>suggestion is highly appreciated. Thank you very much.
>
>Kim Titu
>
If you're using positional parameter binding with DCOracle2, you use 
something like
cursor.execute('SELECT * FROM EMP WHERE EMPNO = :1', empno) -- so the 
SQL statement is untouched from what you passed in.  The only time 
DCOracle2 constructs a statement is during stored procedure execution.

>