Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable substitution
Message
De
29/12/2000 08:58:16
 
 
À
29/12/2000 08:45:43
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00457423
Message ID:
00457716
Vues:
20
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
Fil
Voir

Click here to load this message in the networking platform