DBMS_TRACE.PLSQL_TRACE_VERSION : DBMS_TRACE « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_TRACE

DBMS_TRACE.PLSQL_TRACE_VERSION

 
SQL>
SQL> set serveroutput on
SQL>
SQL> DECLARE
  2    v_MajorVersion BINARY_INTEGER;
  3    v_MinorVersion BINARY_INTEGER;
  4  BEGIN
  5    DBMS_TRACE.PLSQL_TRACE_VERSION(v_MajorVersion, v_MinorVersion);
  6    DBMS_OUTPUT.PUT_LINE('Trace major version: ' || v_MajorVersion);
  7    DBMS_OUTPUT.PUT_LINE('Trace minor version: ' || v_MinorVersion);
  8  END;
  9  /
Trace major version: 1
Trace minor version: 0

PL/SQL procedure successfully completed.

SQL>
SQL>

 

Related examples in the same category