FUNCTION: SYS.CHECK_VERSION

Source

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
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;