An example of using DBMS_SQL.OPEN_CURSOR : DBMS_SQL « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_SQL

SQL> 
SQL> DECLARE
  2    tableName VARCHAR2(30):='temp';
  3    sqlString VARCHAR2(150);
  4    c INTEGER;
  5    ret_code INTEGER;
  6  BEGIN
  7    sqlString :='create table '||tableName||'(col1 NUMBER NOT NULL)';
  8    c :=DBMS_SQL.OPEN_CURSOR;
  9    DBMS_SQL.PARSE(c,sqlString,DBMS_SQL.V7);
 10    ret_code :=DBMS_SQL.EXECUTE(c);
 11    DBMS_SQL.CLOSE_CURSOR(c);
 12  END;
 13  /

PL/SQL procedure successfully completed.

SQL> drop table temp;

Table dropped.