|
SQL>
SQL> CREATE OR REPLACE PROCEDURE show_parameters
2 IS
3 BEGIN
4 IF $$PLSQL_DEBUG THEN
5 DBMS_OUTPUT.PUT_LINE ('DEBUG ON');
6 ELSE
7 DBMS_OUTPUT.PUT_LINE ('DEBUG OFF');
8 END IF;
9 DBMS_OUTPUT.PUT_LINE ($$PLSQL_OPTIMIZE_LEVEL);
10 DBMS_OUTPUT.PUT_LINE ($$PLSQL_CODE_TYPE);
11 DBMS_OUTPUT.PUT_LINE ($$PLSQL_WARNINGS);
12 DBMS_OUTPUT.PUT_LINE ($$NLS_LENGTH_SEMANTICS);
13 END show_parameters;
14 /
Procedure created.
|