DBA Data[Home] [Help]

PACKAGE: CTXSYS.DRVDISP

Source


1 package drvdisp authid current_user is
2 
3   /*
4    * NAME
5    *   EXECTRUST - synchronous trust callout command
6    *
7    * RETURN
8    *
9    */
10   procedure EXECTRUST(
11                      idx_owner  in     varchar2,
12                      idx_name   in     varchar2,
13                      part_name  in     varchar2,
14                      func_code  in     number,
15   		     arg1       in     varchar2 default NULL,
16   		     arg2       in     varchar2 default NULL,
17   		     arg3       in     varchar2 default NULL,
18   		     arg4       in     varchar2 default NULL,
19   		     arg5       in     varchar2 default NULL,
20   		     arg6       in     varchar2 default NULL,
21   		     arg7       in     varchar2 default NULL,
22   		     arg8       in     varchar2 default NULL,
23   		     arg9       in     varchar2 default NULL,
24   		     arg10      in     varchar2 default NULL
25                     );
26 
27   /*
28    * NAME
29    *   EXECTRUST_RET - synchronous trust callout command with return
30    *
31    * RETURN
32    *
33    */
34   procedure EXECTRUST_RET(
35                      idx_owner  in     varchar2,
36                      idx_name   in     varchar2,
37                      part_name  in     varchar2,
38                      func_code  in     number,
39                      ret1       out    varchar2,
40                      ret2       out    varchar2,
41   		     arg1       in     varchar2 default NULL,
42   		     arg2       in     varchar2 default NULL,
43   		     arg3       in     varchar2 default NULL,
44   		     arg4       in     varchar2 default NULL,
45   		     arg5       in     varchar2 default NULL,
46   		     arg6       in     varchar2 default NULL,
47   		     arg7       in     varchar2 default NULL,
48   		     arg8       in     varchar2 default NULL,
49   		     arg9       in     varchar2 default NULL,
50   		     arg10      in     varchar2 default NULL
51                     );
52 
53   /*
54    * NAME
55    *   EXECTRUST_RET1 - synchronous trust callout command with 1 return
56    *
57    * RETURN
58    *
59    */
60   function EXECTRUST_RET1(
61                      idx_owner  in     varchar2,
62                      idx_name   in     varchar2,
63                      part_name  in     varchar2,
64                      func_code  in     number,
65   		     arg1       in     varchar2 default NULL,
66   		     arg2       in     varchar2 default NULL,
67   		     arg3       in     varchar2 default NULL,
68   		     arg4       in     varchar2 default NULL,
69   		     arg5       in     varchar2 default NULL,
70   		     arg6       in     varchar2 default NULL,
71   		     arg7       in     varchar2 default NULL,
72   		     arg8       in     varchar2 default NULL,
73   		     arg9       in     varchar2 default NULL,
74   		     arg10      in     varchar2 default NULL
75                     )
76    return varchar2;
77 
78   /*
79    * NAME
80    *   EXECTRUST_ARRAY - synchronous trust callout command with arrays
81    *
82    * RETURN
83    *
84    */
85   procedure EXECTRUST_ARRAY(
86                      idx_owner  in     varchar2,
87                      idx_name   in     varchar2,
88                      part_name  in     varchar2,
89                      func_code  in     number,
90                      list1      in     sys.odcinumberlist,
91                      list2      in     sys.odcinumberlist,
92   		     arg1       in     varchar2 default NULL,
93   		     arg2       in     varchar2 default NULL,
94   		     arg3       in     varchar2 default NULL,
95   		     arg4       in     varchar2 default NULL,
96   		     arg5       in     varchar2 default NULL,
97   		     arg6       in     varchar2 default NULL,
98   		     arg7       in     varchar2 default NULL,
99   		     arg8       in     varchar2 default NULL,
100   		     arg9       in     varchar2 default NULL,
101   		     arg10      in     varchar2 default NULL
102                     );
103 
104   /*
105    * NAME
106    *   EXECASOWN - synchronous trust callout command
107    *
108    * RETURN
109    *
110    */
111   procedure EXECASOWN(
112                      idx_ownid  in     number,
113                      idx_owner  in     varchar2,
114                      idx_name   in     varchar2,
115                      part_name  in     varchar2,
116                      func_code  in     number,
117   		     arg1       in     varchar2 default NULL,
118   		     arg2       in     varchar2 default NULL,
119   		     arg3       in     varchar2 default NULL,
120   		     arg4       in     varchar2 default NULL,
121   		     arg5       in     varchar2 default NULL,
122   		     arg6       in     varchar2 default NULL,
123   		     arg7       in     varchar2 default NULL,
124   		     arg8       in     varchar2 default NULL,
125   		     arg9       in     varchar2 default NULL,
126   		     arg10      in     varchar2 default NULL,
127   		     arg11      in     varchar2 default NULL
128                     );
129 
130   /*
131    * NAME
132    *   EXECASOWN_CLOB - synchronous trust callout command w/ INOUT clob
133    *
134    * RETURN
135    *
136    */
137   procedure EXECASOWN_CLOB(
138                      idx_ownid  in     number,
139                      idx_owner  in     varchar2,
140                      idx_name   in     varchar2,
141                      part_name  in     varchar2,
142                      func_code  in     number,
143                      argclob    in out nocopy clob,
144   		     arg1       in     varchar2 default NULL,
145   		     arg2       in     varchar2 default NULL,
146   		     arg3       in     varchar2 default NULL,
147   		     arg4       in     varchar2 default NULL,
148   		     arg5       in     varchar2 default NULL,
149   		     arg6       in     varchar2 default NULL,
150   		     arg7       in     varchar2 default NULL,
151   		     arg8       in     varchar2 default NULL,
152   		     arg9       in     varchar2 default NULL,
153   		     arg10      in     varchar2 default NULL,
154   		     arg11      in     varchar2 default NULL
155                     );
156 
157   /*
158    * NAME
159    *   EXECASOWN_IN_CLOB - synchronous trust callout command w/ IN clob
160    *
161    * RETURN
162    *
163    */
164   procedure EXECASOWN_IN_CLOB(
165                      idx_ownid  in     number,
166                      idx_owner  in     varchar2,
167                      idx_name   in     varchar2,
168                      part_name  in     varchar2,
169                      func_code  in     number,
170                      argclob    in     clob,
171   		     arg1       in     varchar2 default NULL,
172   		     arg2       in     varchar2 default NULL,
173   		     arg3       in     varchar2 default NULL,
174   		     arg4       in     varchar2 default NULL,
175   		     arg5       in     varchar2 default NULL,
176   		     arg6       in     varchar2 default NULL,
177   		     arg7       in     varchar2 default NULL,
178   		     arg8       in     varchar2 default NULL,
179   		     arg9       in     varchar2 default NULL,
180   		     arg10      in     varchar2 default NULL
181                     );
182 
183   /*
184    * NAME
185    *   EXECASOWN_IN_OUT_CLOBS -
186    *     synchronous trust callout command w/
187    *       one IN clob and one IN OUT clob.
188    *
189    * RETURN
190    *
191    */
192   procedure EXECASOWN_IN_OUT_CLOBS(
193                      idx_ownid  in     number,
194                      idx_owner  in     varchar2,
195                      idx_name   in     varchar2,
196                      part_name  in     varchar2,
197                      func_code  in     number,
198                      argclob1   in     clob,
199                      argclob2   in out nocopy clob,
200   		     arg1       in     varchar2 default NULL,
201   		     arg2       in     varchar2 default NULL,
202   		     arg3       in     varchar2 default NULL,
203   		     arg4       in     varchar2 default NULL,
204   		     arg5       in     varchar2 default NULL,
205   		     arg6       in     varchar2 default NULL,
206   		     arg7       in     varchar2 default NULL,
207   		     arg8       in     varchar2 default NULL,
208   		     arg9       in     varchar2 default NULL,
209   		     arg10      in     varchar2 default NULL,
210   		     arg11      in     varchar2 default NULL
211                     );
212 
213   /*
214    * NAME
215    *   EXECASOWN_IN_CLOB_RET - synchronous trust callout command with return
216    *
217    * RETURN
218    *
219    */
220   procedure EXECASOWN_IN_CLOB_RET(
221                      idx_ownid  in     number,
222                      idx_owner  in     varchar2,
223                      idx_name   in     varchar2,
224                      part_name  in     varchar2,
225                      func_code  in     number,
226                      ret1       out    varchar2,
227                      ret2       out    varchar2,
228                      argclob    in     clob,
229   		     arg1       in     varchar2 default NULL,
230   		     arg2       in     varchar2 default NULL,
231   		     arg3       in     varchar2 default NULL,
232   		     arg4       in     varchar2 default NULL,
233   		     arg5       in     varchar2 default NULL,
234   		     arg6       in     varchar2 default NULL,
235   		     arg7       in     varchar2 default NULL,
236   		     arg8       in     varchar2 default NULL,
237   		     arg9       in     varchar2 default NULL,
238   		     arg10      in     varchar2 default NULL
239                     );
240 
241   /*
242    * NAME
243    *   EXECASOWN_RET - synchronous trust callout command with return
244    *
245    * RETURN
246    *
247    */
248   procedure EXECASOWN_RET(
249                      idx_ownid  in     number,
250                      idx_owner  in     varchar2,
251                      idx_name   in     varchar2,
252                      part_name  in     varchar2,
253                      func_code  in     number,
254                      ret1       out    varchar2,
255                      ret2       out    varchar2,
256   		     arg1       in     varchar2 default NULL,
257   		     arg2       in     varchar2 default NULL,
258   		     arg3       in     varchar2 default NULL,
259   		     arg4       in     varchar2 default NULL,
260   		     arg5       in     varchar2 default NULL,
261   		     arg6       in     varchar2 default NULL,
262   		     arg7       in     varchar2 default NULL,
263   		     arg8       in     varchar2 default NULL,
264   		     arg9       in     varchar2 default NULL,
265   		     arg10      in     varchar2 default NULL
266                     );
267 
268   /*
269    * NAME
270    *   EXECASOWN_RET1 - synchronous trust callout command with 1 return
271    *
272    * RETURN
273    *
274    */
275   function EXECASOWN_RET1(
276                      idx_ownid  in     number,
277                      idx_owner  in     varchar2,
278                      idx_name   in     varchar2,
279                      part_name  in     varchar2,
280                      func_code  in     number,
281   		     arg1       in     varchar2 default NULL,
282   		     arg2       in     varchar2 default NULL,
283   		     arg3       in     varchar2 default NULL,
284   		     arg4       in     varchar2 default NULL,
285   		     arg5       in     varchar2 default NULL,
286   		     arg6       in     varchar2 default NULL,
287   		     arg7       in     varchar2 default NULL,
288   		     arg8       in     varchar2 default NULL,
289   		     arg9       in     varchar2 default NULL,
290   		     arg10      in     varchar2 default NULL
291                     )
292    return varchar2;
293 
294 /*--------------------------- tablefunc ----------------------------*/
295 
296 FUNCTION tablefunc
297 (
298   idxo      in  varchar2,
299   idxn      in  varchar2,
300   idxp      in  varchar2,
301   cur       in  SYS_REFCURSOR,
302   opcode    in  varchar2,
303   memory    in  varchar2,
304   tstamp    in  varchar2,
305   direct_path in varchar2,
306   maxtime     in varchar2
307 ) return number;
308 
309 /*--------------------------- tablefunc_asown ----------------------------*/
310 
311 FUNCTION tablefunc_asown
312 (
313   idxownid  in  number,
314   idxo      in  varchar2,
315   idxn      in  varchar2,
316   idxp      in  varchar2,
317   cur       in  SYS_REFCURSOR,
318   opcode    in  varchar2,
319   memory    in  varchar2,
320   tstamp    in  varchar2,
321   direct_path in varchar2,
322   maxtime     in varchar2
323 ) return number;
324 
325 end drvdisp;