[Home] [Help]
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
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;