Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable substitution
Message
From
29/12/2000 08:58:16
 
 
To
29/12/2000 08:45:43
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00457423
Message ID:
00457716
Views:
19
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
Map
View

Click here to load this message in the networking platform