I believe DBMS_SQL will work on 7.33 but you need to change DBMS_SQL.NATIVE
in the statement DBMS_SQL.PARSE(csr_handle,l_sql,DBMS_SQL.NATIVE).
I think to DBMS_SQL.V733 or something like that. Sorry I can't remember...This but look up the DBMS_SQL package in the 7.33 help. (Look at any example of using DBMS_SQL...)
Also note you could code the SQL statement the same way with the for loop.
At any rate the DBMS_SQL is so extremely useful for dynamic SQL I reccomend you research it in your oracle help files.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only