Did you try it?
I am not sure about v7.
But under 8.1.5 it works.
And why 'parse' should necessarily use 'dbms_sql.v7' ?
Here is an example, which proves, that for DDL it's
enough to call 'parse' without 'execute':
SQLWKS> declare cur1 integer; 2> begin 3> cur1 := dbms_sql.open_cursor; 4> dbms_sql.parse(cur1,'create table ddd(d1 int)', dbms_sql.native); 5> dbms_sql.close_cursor(cur1); 6> end; 7> / Statement processed. SQLWKS> select * from ddd; D1 ---------- 0 rows selected.
|
Title: RE: what's wrong with this...DBMS_SQL
- what's wrong with this...DBMS_SQL Tirumala, Surendra
- RE: what's wrong with this...DBMS_SQL Koivu, Lisa
- RE: what's wrong with this...DBMS_SQL Norrell, Brian
- Re: what's wrong with this...DBMS_SQL Igor Neyman
- RE: what's wrong with this...DBMS_SQL Koivu, Lisa
- RE: what's wrong with this...DBMS_SQL Lord David
- RE: what's wrong with this...DBMS_SQL Joseph Testa
- what's wrong with this...DBMS_SQL Tirumala, Surendra
- RE: what's wrong with this...DBMS_SQL Tirumala, Surendra
- Re: what's wrong with this...DBMS_SQL Igor Neyman
- Re: what's wrong with this...DBMS_SQL Igor Neyman
- Re: what's wrong with this...DBMS_SQL Jared Still
- RE: what's wrong with this...DBMS_SQL Lord David
- Re: what's wrong with this...DBMS_SQL Mitchell
- RE: what's wrong with this...DBMS_SQL Bala, Prakash