[cx-oracle-users] DDL prepared problem

[sky2roy s. <sk...@gm...>]

hi.

I am  working with python 2.4 , cx_Oracle-5.0.3

i am trying to execute ddl sql. but it has an error.

like this sql.  " create table copy_student as select * from student where
std_id = ?"
not exactly this sql ..... just focus on prepared DDL

there is sample code and error message.

sample code
========================
parameters = {}
parameters["std_id"] = "10000"
sql  = " create table copy_student as select * from student where std_id =
:std_id "
cursor.prepare(sql)
cursor.execute(None, parameters)
========================

error message
================

DatabaseError: ORA-01036: illegal variable name/number

=================

i think prepared DDL sql is not bined. so this is bugs or not suppoert sql?