how DDL doesn't work with PL/SQL : Compile Error « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Compile Error

how DDL doesn't work with PL/SQL

    
SQL>
SQL> BEGIN
  2     CREATE TABLE ddl_table (id NUMBER(10));
  3  EXCEPTION
  4     WHEN OTHERS
  5     THEN
  6        DBMS_OUTPUT.PUT_LINE(sqlerrm);
  7  END;
  8  /
SQL>








Related examples in the same category

1.Check the error
2.Check error for procedure
3.Check error form stored procedure
4.PLS-00306: wrong number or types of arguments in call
5.PLS-00363: expression '3' cannot be used as an assignment target
6.Set the PLSQL_WARNING level to DISABLE:ALL
7.This example illustrates the PLS-483 error
8.This package will not compile because the specification and body do not match.
9.Build an anonymous block that will trigger an error.