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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement