Use dbms_sql.open_cursor create a cursor
SQL>
SQL> declare
2 l_cursor number := dbms_sql.open_cursor;
3 l_stmt dbms_sql.varchar2s;
4 begin
5 l_stmt(3) := 'junk';
6 l_stmt(4) := 'create table foo';
7 l_stmt(5) := '( n numb';
8 l_stmt(6) := 'er, v varchar2(100)';
9 l_stmt(7) := ')';
10 l_stmt(8) := 'more junk';
11 dbms_sql.parse( l_cursor,
12 l_stmt,
13 4,
14 7,
15 FALSE,
16 dbms_sql.native );
17 dbms_sql.close_cursor( l_cursor );
18 end;
19 /
PL/SQL procedure successfully completed.
SQL> --
Related examples in the same category