DBA Data[Home] [Help]

SYS.CHECK_VERSION dependencies on DBMS_REGISTRY

Line 5: SELECT substr(dbms_registry.version('CATPROC'), 1, 10)

1: FUNCTION check_version(v_filename IN VARCHAR2)
2: RETURN VARCHAR2 AS
3: version VARCHAR2(10);
4: BEGIN
5: SELECT substr(dbms_registry.version('CATPROC'), 1, 10)
6: INTO version
7: FROM dual;
8:
9: IF (version >= '12.1.0.1' and v_filename != 'catmeta.sql') OR

Line 13: RETURN dbms_registry.nothing_script;

9: IF (version >= '12.1.0.1' and v_filename != 'catmeta.sql') OR
10: (version < '12.1.0.1' and v_filename = 'catmeta.sql') THEN
11: RETURN v_filename;
12: ELSE
13: RETURN dbms_registry.nothing_script;
14: END IF;
15:
16: END check_version;