1 PACKAGE dbms_qopatch AUTHID DEFINER AS
2
3 xslt xmltype := NULL;
4
5 --Provides ORACLE_HOME details
6 function get_opatch_install_info return xmltype;
7
8 --Provides top level patch info for patch
9 function GET_OPATCH_DATA (pnum IN varchar2) return xmltype;
10
11 --Provides bugs list in a patch or all the patches
12 function GET_OPATCH_BUGS (pnum IN varchar2 DEFAULT NULL) return xmltype;
13
14 --Provides list of files modified by a patch or all the patches
15 function GET_OPATCH_FILES (pnum IN varchar2) return xmltype;
16
17 --Provides installed patches total count
18 function GET_OPATCH_COUNT return xmltype;
19
20 -- Get list of patches installed
21 function GET_OPATCH_LIST return xmltype;
22
23 --Provides prerequisite patches for a patch
24 function GET_OPATCH_PREQS (pnum IN varchar2) return xmltype;
25
26 --Provides overlay patches for a patch
27 function GET_OPATCH_OLAYS (pnum IN varchar2) return xmltype;
28
29 --Detects patch conflicts for given files
30 function PATCH_CONFLICT_DETECTION (fileName IN varchar2) return xmltype;
31
32 -- Provides list of patches installed
33 function IS_PATCH_INSTALLED (pnum IN VARCHAR2) return xmltype;
34
35 -- Get sql patch status of all RAC instances
36 function GET_PENDING_ACTIVITY return xmltype;
37
38 -- Set current node, instance name in case of RAC
39 PROCEDURE set_current_opinst(node_name IN VARCHAR2 DEFAULT NULL,
40 inst_name IN VARCHAR2 DEFAULT NULL);
41
42 -- To call job to refresh the inventory
43 PROCEDURE opatch_inv_refresh_job;
44
45 -- To get the stylesheet for result presentation
46 function get_opatch_xslt return xmltype;
47
48 --To get the full opatch lsinventory
49 function get_opatch_lsinventory return xmltype;
50
51 -- To create job on newly added node
52 FUNCTION add_oinv_job(nname VARCHAR2, iname VARCHAR2) RETURN BOOLEAN;
53
54 -- To drop job on deleted node
55 FUNCTION drop_oinv_job(nname VARCHAR2, iname VARCHAR2) RETURN BOOLEAN;
56
57 -- Replaces log ans script directories with correct path
58 PROCEDURE replace_logscrpt_dirs;
59 PROCEDURE replace_dirs_int(pf_id NUMBER);
60
61 -- sqlpatch description from sql registry
62 PROCEDURE get_sqlpatch_status(pnum varchar2 default NULL);
63
64 -- Turn on debug
65 PROCEDURE set_debug(debug IN BOOLEAN);
66
67 -- FLAG for internal testing
68 PROCEDURE skip_sanity_check(skip IN BOOLEAN);
69
70 -- API for cleanup the metadata in case of inconsistency
71 PROCEDURE CLEAN_METADATA;
72
73 END dbms_qopatch;