[Home] [Help]
PACKAGE: SYS.DBMS_STANDARD
Source
1 package dbms_standard is
2 -- types
3 type ora_name_list_t is table of varchar2(64);
4
5 -- DBMS_ID and DBMS_QUOTED_ID define the length of identifiers
6 -- in objects for SQL, PL/SQL and users.
7 subtype dbms_id is varchar2(30);
8 subtype dbms_quoted_id is varchar2(32);
9
10 subtype dbms_id_30 is varchar2(30);
11 subtype dbms_quoted_id_30 is varchar2(32);
12 subtype dbms_id_128 is varchar2(128);
13 subtype dbms_quoted_id_128 is varchar2(130);
14
15 -- Trigger Operations
16 procedure raise_application_error(num binary_integer, msg varchar2,
17 keeperrorstack boolean default FALSE);
18 pragma interface (C, raise_application_error); -- 1 (see psdicd.c)
19 pragma restrict_references (raise_application_error, WNPS, RNPS, WNDS, RNDS);
20 function inserting return boolean;
21 pragma interface (C, inserting); -- 2
22 pragma restrict_references (inserting, WNPS, RNPS, WNDS);
23 function deleting return boolean;
24 pragma interface (C, deleting); -- 3
25 pragma restrict_references (deleting, WNPS, RNPS, WNDS);
26 function updating return boolean;
27 pragma interface (C, updating); -- 4
28 pragma restrict_references (updating, WNPS, RNPS, WNDS);
29 function updating (colnam varchar2) return boolean;
30 pragma interface (C, updating); -- 5
31 pragma restrict_references (updating, WNPS, RNPS, WNDS);
32
33 -- Transaction Commands
34 procedure commit;
35 pragma interface (C, commit); -- 6
36 procedure commit_cm(vc varchar2);
37 pragma interface (C, commit_cm); -- 7
38 procedure rollback_nr;
39 pragma interface (C, rollback_nr); -- 8
40 procedure rollback_sv(save_point varchar2);
41 pragma interface (C, rollback_sv); -- 9
42 procedure savepoint(save_point varchar2);
43 pragma interface (C, savepoint); -- 10
44 procedure set_transaction_use(vc varchar2);
45 pragma interface (C, set_transaction_use); -- 11
46
47
48 -- Functions supported for system events
49 -- Null or zero will be returned if called in inappropriate occasions
50 -- error functions only search for the top 5 errors in the error stack
51
52 function sysevent return varchar2 ; -- 12
53 pragma interface (C, sysevent);
54 pragma restrict_references (sysevent, WNPS, RNPS, WNDS);
55 function dictionary_obj_type return varchar2 ; -- 13
56 pragma interface (C, dictionary_obj_type);
57 pragma restrict_references (dictionary_obj_type, WNPS, RNPS, WNDS);
58 function dictionary_obj_owner return varchar2 ; -- 14
59 pragma interface (C, dictionary_obj_owner);
60 pragma restrict_references (dictionary_obj_owner, WNPS, RNPS, WNDS);
61 function dictionary_obj_name return varchar2 ; -- 15
62 pragma interface (C, dictionary_obj_name);
63 pragma restrict_references (dictionary_obj_name, WNPS, RNPS, WNDS);
64 function database_name return varchar2 ; -- 16
65 pragma interface (C, database_name);
66 pragma restrict_references (database_name, WNPS, RNPS, WNDS);
67 function instance_num return binary_integer ; -- 17
68 pragma interface (C, instance_num);
69 pragma restrict_references (instance_num, WNPS, RNPS, WNDS);
70 function login_user return varchar2 ; -- 18
71 pragma interface (C, login_user);
72 pragma restrict_references (login_user, WNPS, RNPS, WNDS);
73 function is_servererror (errno binary_integer)
74 return boolean ; -- 19
75 pragma interface (C, is_servererror);
76 pragma restrict_references (is_servererror, WNPS, RNPS, WNDS);
77
78 function server_error(position binary_integer)
79 return binary_integer ; -- 20
80 pragma interface (C, server_error);
81 pragma restrict_references (server_error, WNPS, RNPS, WNDS);
82 function des_encrypted_password(user varchar2 default null) return varchar2; -- 21
83 pragma interface (C, des_encrypted_password);
84 pragma restrict_references (des_encrypted_password, WNPS, RNPS, WNDS);
85 function is_alter_column (column_name varchar2)
86 return boolean ; -- 22
87 pragma interface (C, is_alter_column);
88 pragma restrict_references (is_alter_column, WNPS, RNPS, WNDS);
89 function is_drop_column (column_name varchar2)
90 return boolean ; -- 23
91 pragma interface (C, is_drop_column);
92 pragma restrict_references (is_drop_column, WNPS, RNPS, WNDS);
93 function grantee (user_list out ora_name_list_t) return binary_integer ; -- 24
94 pragma interface (C, grantee);
95 pragma restrict_references (grantee, WNPS, RNPS, WNDS);
96 function revokee (user_list out ora_name_list_t) return binary_integer ; -- 25
97 pragma interface (C, revokee);
98 pragma restrict_references (revokee, WNPS, RNPS, WNDS);
99 function privilege_list (priv_list out ora_name_list_t)
100 return binary_integer ; -- 26
101 pragma interface (C, privilege_list);
102 pragma restrict_references (privilege_list, WNPS, RNPS, WNDS);
103 function with_grant_option return boolean ; -- 27
104 pragma interface (C, with_grant_option);
105 pragma restrict_references (with_grant_option, WNPS, RNPS, WNDS);
106 function dictionary_obj_owner_list (owner_list out ora_name_list_t)
107 return binary_integer; -- 28
108 pragma interface (C, dictionary_obj_owner_list);
109 pragma restrict_references (dictionary_obj_owner_list, WNPS, RNPS, WNDS);
110 function dictionary_obj_name_list (object_list out ora_name_list_t)
111 return binary_integer; -- 29
112 pragma interface (C, dictionary_obj_name_list);
113 pragma restrict_references (dictionary_obj_name_list, WNPS, RNPS, WNDS);
114 function is_creating_nested_table return boolean; -- 30
115 pragma interface (C, is_creating_nested_table);
116 pragma restrict_references (is_creating_nested_table, WNPS, RNPS, WNDS);
117 function client_ip_address return varchar2; -- 31
118 pragma interface (C, client_ip_address);
119 pragma restrict_references (client_ip_address, WNPS, RNPS, WNDS);
120 function sql_txt (sql_text out ora_name_list_t) return binary_integer; -- 32
121 pragma interface (C, sql_txt);
122 pragma restrict_references (sql_txt, WNPS, RNPS, WNDS);
123 function server_error_msg (position binary_integer) return varchar2; -- 33
124 pragma interface (C, server_error_msg);
125 pragma restrict_references (server_error_msg, WNPS, RNPS, WNDS);
126 function server_error_depth return binary_integer; -- 34
127 pragma interface (C, server_error_depth);
128 pragma restrict_references (server_error_depth, WNPS, RNPS, WNDS);
129 function server_error_num_params (position binary_integer)
130 return binary_integer; -- 35
131 pragma interface (C, server_error_num_params);
132 pragma restrict_references (server_error_num_params, WNPS, RNPS, WNDS);
133 function server_error_param(position binary_integer, param binary_integer)
134 return varchar2; -- 36
135 pragma interface (C, server_error_param);
136 pragma restrict_references (server_error_param, WNPS, RNPS, WNDS);
137 function partition_pos return binary_integer; -- 37
138 pragma interface (C, partition_pos);
139 pragma restrict_references (partition_pos, WNPS, RNPS, WNDS);
140
141 function sys_GetTriggerState return pls_integer;
142 pragma interface (C, Sys_GetTriggerState); -- 38
143 pragma restrict_references (Sys_GetTriggerState, wnds, RNDS);
144 function applying_crossedition_trigger return boolean;
145 pragma interface (C, applying_crossedition_trigger); -- 39
146 pragma restrict_references (applying_crossedition_trigger, WNPS,RNPS,WNDS);
147
148 function original_sql_txt (sql_text out ora_name_list_t)
149 return binary_integer; -- 40
150 pragma interface (C, original_sql_txt);
151 pragma restrict_references (original_sql_txt, WNPS, RNPS, WNDS);
152
153 end;