The GET_VERSION procedure returns the current DBMS_PROFILER version.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_PROFILER.GET_VERSION (
major OUT BINARY_INTEGER,
minor OUT BINARY_INTEGER);
Parameters
| Parameter | Description |
|---|---|
| major | The major version of DBMS_PROFILER. |
| minor | The minor version of DBMS_PROFILER. |
Examples
obclient [SYS]> DECLARE
-> -- Define variables to store the major and minor versions.
-> l_major BINARY_INTEGER;
-> l_minor BINARY_INTEGER;
-> BEGIN
-> -- Call the GET_VERSION procedure in the DBMS_PROFILER package.
-> DBMS_PROFILER.get_version(l_major, l_minor);
->
-> -- Return the results to the console.
-> DBMS_OUTPUT.PUT_LINE('DBMS_PROFILER Major Version: ' || l_major);
-> DBMS_OUTPUT.PUT_LINE('DBMS_PROFILER Minor Version: ' || l_minor);
-> END;
-> /
Query OK, 1 row affected (0.155 sec)
DBMS_PROFILER Major Version: 2
DBMS_PROFILER Minor Version: 0