DDL doesn't work with PL/SQL : DDL Statement « PL SQL Statements « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> BEGIN
  2     CREATE TABLE ddl_table (
  3        id NUMBER(10));
  4  EXCEPTION
  5     WHEN OTHERS
  6     THEN
  7        DBMS_OUTPUT.PUT_LINE(sqlerrm);
  8  END;
  9  /
   CREATE TABLE ddl_table (
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe


SQL>








22.9.DDL Statement
22.9.1.DDL doesn't work with PL/SQL