Oracle PL/SQL Tutorial/PL SQL Statements/DDL Statement

Материал из SQL эксперт
Перейти к: навигация, поиск

DDL doesn"t work with PL/SQL

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>