1 PACKAGE dbms_defer_query AUTHID CURRENT_USER AS
2 -------------------
3 -- OVERVIEW
4 --
5 -- This package permits querying the deferred RPC queue data that
6 -- is not exposed through views.
7
8 -------------
9 -- CONSTANTS
10 --
11 -- constants used in the arg_type column of the def$_args table
12 -- definitions copied from dtydef.h
13 --
14 arg_type_num CONSTANT NUMBER := 2; -- DTYNUM
15 arg_type_char CONSTANT NUMBER := 96; -- DTYAFC
16 arg_type_varchar2 CONSTANT NUMBER := 1; -- DTYCHAR
17 arg_type_date CONSTANT NUMBER := 12; -- DTYDAT
18 arg_type_rowid CONSTANT NUMBER := 11; -- DTYRID
19 arg_type_raw CONSTANT NUMBER := 23; -- DTYBIN
20 arg_type_blob CONSTANT NUMBER := 113; -- DTYBLOB
21 arg_type_clob CONSTANT NUMBER := 112; -- DTYCLOB
22 arg_type_bfil CONSTANT NUMBER := 114; -- DTYBFIL
23 arg_type_cfil CONSTANT NUMBER := 115; -- DTYCFIL
24 arg_type_time CONSTANT NUMBER := 178; -- DTYTIME
25 arg_type_ttz CONSTANT NUMBER := 179; -- DTYTTZ
26 arg_type_timestamp CONSTANT NUMBER := 180; -- DTYSTAMP
27 arg_type_tstz CONSTANT NUMBER := 181; -- DTYSTZ
28 arg_type_iym CONSTANT NUMBER := 182; -- DTYIYM
29 arg_type_ids CONSTANT NUMBER := 183; -- DTYIDS
30 arg_type_tsltz CONSTANT NUMBER := 231; -- DTYSITZ
31 -----------
32 -- the following constants are added for replicated objects
33 --
34 arg_type_object_null_vector CONSTANT NUMBER := 121; -- DTYADT
35 -- anydata includes instance for VARRAY, Nested Table, Object Type, REF Type
36 -- and Opaque type.
37 arg_type_anydata CONSTANT NUMBER := 109; -- DTYINTY
38
39 -- constants derived from SQLCS_% constants in sqldef.h
40 arg_csetid_none CONSTANT NUMBER := 0; -- DATE, NUMBER, ROWID, RAW, BLOB
41 -- user-defined types
42 arg_form_none CONSTANT NUMBER := 0; -- DATE, NUMBER, ROWID, RAW, BLOB
43 -- user-defined types
44 arg_form_implicit CONSTANT NUMBER := 1; -- CHAR, VARCHAR2, CLOB
45 arg_form_nchar CONSTANT NUMBER := 2; -- NCHAR, NVARCHAR2, NCLOB
46 arg_form_any CONSTANT NUMBER := 4;
47 -- definition same as dbms_repcat_mas.repcat_status_normal
48 -- (don't want to require repcat to be loaded)
49 repcat_status_normal CONSTANT NUMBER := 0.0;
50
51 -- The following type declaration are used by get_call_args call.
52 TYPE type_ary is table of number
53 index by binary_integer;
54
55 TYPE val_ary is table of varchar2(2000)
56 index by binary_integer;
57
58 FUNCTION get_arg_type(callno IN NUMBER,
59 arg_no IN NUMBER,
60 deferred_tran_id IN VARCHAR2)
61 RETURN NUMBER;
62 -- Return type of a deferred call parameter.
63 -- Input parameters
64 -- callno
65 -- call identifier from the defCall view
66 -- arg_no
67 -- position of desired parameter in calls argument list
68 -- parameter positions are 1..number of parameters in call
69 -- deferred_tran_id
70 -- deferred transaction id
71 ----
72 -- Result
73 -- The type of the deferred rpc parameter.
74 ------
75 -- EXCEPTIONS
76 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
77 -- queue tables.
78 ------
79
80 FUNCTION get_arg_csetid(callno IN NUMBER,
81 arg_no IN NUMBER,
82 deferred_tran_id IN VARCHAR2)
83 RETURN NUMBER;
84 -- Return the character set id of a deferred call parameter.
85 -- Input parameters
86 -- callno
87 -- call identifier from the defCall view
88 -- arg_no
89 -- position of desired parameter in calls argument list
90 -- parameter positions are 1..number of parameters in call
91 -- deferred_tran_id
92 -- deferred transaction id
93 ----
94 -- Result
95 -- The character set id of the deferred rpc parameter.
96 ------
97 -- EXCEPTIONS
98 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
99 -- queue tables.
100 ------
101
102 FUNCTION get_arg_form(callno IN NUMBER,
103 arg_no IN NUMBER,
104 deferred_tran_id IN VARCHAR2)
105 RETURN NUMBER;
106 -- Return the character set form of a deferred call parameter.
107 -- Input parameters
108 -- callno
109 -- call identifier from the defCall view
110 -- arg_no
111 -- position of desired parameter in calls argument list
112 -- parameter positions are 1..number of parameters in call
113 -- deferred_tran_id
114 -- deferred transaction id
115 ----
116 -- Result
117 -- The character set form of the deferred rpc parameter.
118 -- Examples include dbms_defer.arg_form_implicit and
119 -- dbms_defer.arg_form_nchar.
120 ------
121 -- EXCEPTIONS
122 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
123 -- queue tables.
124 ------
125 FUNCTION get_number_arg(callno IN NUMBER,
126 arg_no IN NUMBER,
127 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
128 RETURN NUMBER;
129 -- Return a deferred call parameter.
130 -- Input parameters
131 -- callno
132 -- call identifier from the defCall view
133 -- arg_no
134 -- position of desired parameter in calls argument list
135 -- parameter positions are 1..number of parameters in call
136 -- deferred_tran_id
137 -- deferred transaction id, defaults to one passed in get_arg_type
138 ----
139 -- Result
140 -- The value of the parameter .
141 ------
142 -- EXCEPTIONS
143 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
144 -- queue tables.
145 -- WRONG_TYPE if the desired parameter is not a number.
146 -------
147 FUNCTION get_varchar2_arg(callno IN NUMBER,
148 arg_no IN NUMBER,
149 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
150 RETURN VARCHAR2;
151 -- Return a deferred call parameter.
152 -- Input parameters
153 -- callno
154 -- call identifier from the defCall view
155 -- arg_no
156 -- position of desired parameter in calls argument list
157 -- parameter positions are 1..number of parameters in call
158 -- deferred_tran_id
159 -- deferred transaction id, defaults to one passed in get_arg_type
160 ----
161 -- Result
162 -- The value of the parameter .
163 ------
164 -- EXCEPTIONS
165 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
166 -- queue tables.
167 -- WRONG_TYPE if the desired parameter is not a VARCHAR2.
168 -------
169 FUNCTION get_nvarchar2_arg(callno IN NUMBER,
170 arg_no IN NUMBER,
171 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
172 RETURN NVARCHAR2;
173 -- Return a deferred call parameter.
174 -- Input parameters
175 -- callno
176 -- call identifier from the defCall view
177 -- arg_no
178 -- position of desired parameter in calls argument list
179 -- parameter positions are 1..number of parameters in call
180 -- deferred_tran_id
181 -- deferred transaction id, defaults to one passed in get_arg_type
182 ----
183 -- Result
184 -- The value of the parameter .
185 ------
186 -- EXCEPTIONS
187 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
188 -- queue tables.
189 -- WRONG_TYPE if the desired parameter is not an NVARCHAR2.
190 -------
191 FUNCTION get_char_arg(callno IN NUMBER,
192 arg_no IN NUMBER,
193 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
194 RETURN CHAR;
195 -- Return type of a deferred call parameter.
196 -- Input parameters
197 -- callno
198 -- call identifier from the defCall view
199 -- arg_no
200 -- position of desired parameter in calls argument list
201 -- parameter positions are 1..number of parameters in call
202 -- deferred_tran_id
203 -- deferred transaction id, defaults to one passed in get_arg_type
204 ----
205 -- Result
206 -- The value of the parameter .
207 ------
208 -- EXCEPTIONS
209 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
210 -- queue tables.
211 -- WRONG_TYPE if the desired parameter is not a char.
212 -------
213 FUNCTION get_nchar_arg(callno IN NUMBER,
214 arg_no IN NUMBER,
215 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
216 RETURN NCHAR;
217 -- Return type of a deferred call parameter.
218 -- Input parameters
219 -- callno
220 -- call identifier from the defCall view
221 -- arg_no
222 -- position of desired parameter in calls argument list
223 -- parameter positions are 1..number of parameters in call
224 -- deferred_tran_id
225 -- deferred transaction id, defaults to one passed in get_arg_type
226 ----
227 -- Result
228 -- The value of the parameter .
229 ------
230 -- EXCEPTIONS
231 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
232 -- queue tables.
233 -- WRONG_TYPE if the desired parameter is not an nchar.
234 -------
235 FUNCTION get_date_arg(callno IN NUMBER,
236 arg_no IN NUMBER,
237 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
238 RETURN DATE;
239 -- Return a deferred call parameter.
240 -- Input parameters
241 -- callno
242 -- call identifier from the defCall view
243 -- arg_no
244 -- position of desired parameter in calls argument list
245 -- parameter positions are 1..number of parameters in call
246 -- deferred_tran_id
247 -- deferred transaction id, defaults to one passed in get_arg_type
248 ----
249 -- Result
250 -- The value of the parameter .
251 ------
252 -- EXCEPTIONS
253 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
254 -- queue tables.
255 -- WRONG_TYPE if the desired parameter is not a date.
256 -------
257 FUNCTION get_raw_arg(callno IN NUMBER,
258 arg_no IN NUMBER,
259 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
260 RETURN RAW;
261 -- Return a deferred call parameter.
262 -- Input parameters
263 -- callno
264 -- call identifier from the defCall view
265 -- arg_no
266 -- position of desired parameter in calls argument list
267 -- parameter positions are 1..number of parameters in call
268 -- deferred_tran_id
269 -- deferred transaction id, defaults to one passed in get_arg_type
270 ----
271 -- Result
272 -- The value of the parameter .
273 ------
274 -- EXCEPTIONS
275 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
276 -- queue tables.
277 -- WRONG_TYPE if the desired parameter is not a raw.
278 -------
279 FUNCTION get_rowid_arg(callno IN NUMBER,
280 arg_no IN NUMBER,
281 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
282 RETURN ROWID;
283 -- Return a deferred call parameter.
284 -- Input parameters
285 -- callno
286 -- call identifier from the defCall view
287 -- arg_no
288 -- position of desired parameter in calls argument list
289 -- parameter positions are 1..number of parameters in call
290 -- deferred_tran_id
291 -- deferred transaction id, defaults to one passed in get_arg_type
292 ----
293 -- Result
294 -- The value of the parameter .
295 ------
296 -- EXCEPTIONS
297 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
298 -- queue tables.
299 -- WRONG_TYPE if the desired parameter is not a rowid.
300 -------
301 FUNCTION get_blob_arg(callno IN NUMBER,
302 arg_no IN NUMBER,
303 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
304 RETURN BLOB;
305 -- Return a deferred call parameter.
306 -- Input parameters
307 -- callno
308 -- call identifier from the defCall view
309 -- arg_no
310 -- position of desired parameter in calls argument list
311 -- parameter positions are 1..number of parameters in call
312 -- deferred_tran_id
313 -- deferred transaction id, defaults to one passed in get_arg_type
314 ----
315 -- Result
316 -- The value of the parameter.
317 ------
318 -- EXCEPTIONS
319 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
320 -- queue tables.
321 -- WRONG_TYPE if the desired parameter is not a blob.
322 -------
323 FUNCTION get_clob_arg(callno IN NUMBER,
324 arg_no IN NUMBER,
325 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
326 RETURN CLOB;
327 -- Return a deferred call parameter.
328 -- Input parameters
329 -- callno
330 -- call identifier from the defCall view
331 -- arg_no
332 -- position of desired parameter in calls argument list
333 -- parameter positions are 1..number of parameters in call
334 -- deferred_tran_id
335 -- deferred transaction id, defaults to one passed in get_arg_type
336 ----
337 -- Result
338 -- The value of the parameter.
339 ------
340 -- EXCEPTIONS
341 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
342 -- queue tables.
343 -- WRONG_TYPE if the desired parameter is not a clob.
344 -------
345 FUNCTION get_nclob_arg(callno IN NUMBER,
346 arg_no IN NUMBER,
347 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
348 RETURN NCLOB;
349 -- Return a deferred call parameter.
350 -- Input parameters
351 -- callno
352 -- call identifier from the defCall view
353 -- arg_no
354 -- position of desired parameter in calls argument list
355 -- parameter positions are 1..number of parameters in call
356 -- deferred_tran_id
357 -- deferred transaction id, defaults to one passed in get_arg_type
358 ----
359 -- Result
360 -- The value of the parameter.
361 ------
362 -- EXCEPTIONS
363 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
364 -- queue tables.
365 -- WRONG_TYPE if the desired parameter is not an nclob.
366 -------
367 FUNCTION get_time_arg(callno IN NUMBER,
368 arg_no IN NUMBER,
369 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
370 RETURN TIME_UNCONSTRAINED;
371 -- Return a deferred call parameter.
372 -- Input parameters
373 -- callno
374 -- call identifier from the defCall view
375 -- arg_no
376 -- position of desired parameter in calls argument list
377 -- parameter positions are 1..number of parameters in call
378 -- deferred_tran_id
379 -- deferred transaction id, defaults to one passed in get_arg_type
380 ----
381 -- Result
382 -- The value of the parameter .
383 ------
384 -- EXCEPTIONS
385 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
386 -- queue tables.
387 -- WRONG_TYPE if the desired parameter is not a time.
388 -------
389 FUNCTION get_timestamp_arg(callno IN NUMBER,
390 arg_no IN NUMBER,
391 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
392 RETURN TIMESTAMP_UNCONSTRAINED;
393 -- Return a deferred call parameter.
394 -- Input parameters
395 -- callno
396 -- call identifier from the defCall view
397 -- arg_no
398 -- position of desired parameter in calls argument list
402 ----
399 -- parameter positions are 1..number of parameters in call
400 -- deferred_tran_id
401 -- deferred transaction id, defaults to one passed in get_arg_type
403 -- Result
404 -- The value of the parameter .
405 ------
406 -- EXCEPTIONS
407 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
408 -- queue tables.
409 -- WRONG_TYPE if the desired parameter is not a timestamp.
410 -------
411 FUNCTION get_ttz_arg(callno IN NUMBER,
412 arg_no IN NUMBER,
413 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
414 RETURN TIME_TZ_UNCONSTRAINED;
415 -- Return a deferred call parameter.
416 -- Input parameters
417 -- callno
418 -- call identifier from the defCall view
419 -- arg_no
420 -- position of desired parameter in calls argument list
421 -- parameter positions are 1..number of parameters in call
422 -- deferred_tran_id
423 -- deferred transaction id, defaults to one passed in get_arg_type
424 ----
425 -- Result
426 -- The value of the parameter .
427 ------
428 -- EXCEPTIONS
429 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
430 -- queue tables.
431 -- WRONG_TYPE if the desired parameter is not time with time zone.
432 -------
433 FUNCTION get_tstz_arg(callno IN NUMBER,
434 arg_no IN NUMBER,
435 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
436 RETURN TIMESTAMP_TZ_UNCONSTRAINED;
437 -- Return a deferred call parameter.
438 -- Input parameters
439 -- callno
440 -- call identifier from the defCall view
441 -- arg_no
442 -- position of desired parameter in calls argument list
443 -- parameter positions are 1..number of parameters in call
444 -- deferred_tran_id
445 -- deferred transaction id, defaults to one passed in get_arg_type
446 ----
447 -- Result
448 -- The value of the parameter .
449 ------
450 -- EXCEPTIONS
451 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
452 -- queue tables.
453 -- WRONG_TYPE if the desired parameter is not timestamp with time zone.
454 -------
455 FUNCTION get_tsltz_arg(callno IN NUMBER,
456 arg_no IN NUMBER,
457 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
458 RETURN TIMESTAMP_LTZ_UNCONSTRAINED;
459 -- Return a deferred call parameter.
460 -- Input parameters
461 -- callno
462 -- call identifier from the defCall view
463 -- arg_no
464 -- position of desired parameter in calls argument list
465 -- parameter positions are 1..number of parameters in call
466 -- deferred_tran_id
467 -- deferred transaction id, defaults to one passed in get_arg_type
468 ----
469 -- Result
470 -- The value of the parameter .
471 ------
472 -- EXCEPTIONS
473 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
474 -- queue tables.
475 -- WRONG_TYPE if the desired parameter is not timestamp with local
476 -- time zone.
477 -------
478 FUNCTION get_iym_arg(callno IN NUMBER,
479 arg_no IN NUMBER,
480 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
481 RETURN yminterval_UNCONSTRAINED;
482 -- Return a deferred call parameter.
483 -- Input parameters
484 -- callno
485 -- call identifier from the defCall view
486 -- arg_no
487 -- position of desired parameter in calls argument list
488 -- parameter positions are 1..number of parameters in call
489 -- deferred_tran_id
490 -- deferred transaction id, defaults to one passed in get_arg_type
491 ----
492 -- Result
493 -- The value of the parameter .
494 ------
495 -- EXCEPTIONS
496 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
497 -- queue tables.
498 -- WRONG_TYPE if the desired parameter is not interval year to month.
499 -------
500 FUNCTION get_ids_arg(callno IN NUMBER,
501 arg_no IN NUMBER,
502 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
503 RETURN DSINTERVAL_UNCONSTRAINED;
504 -- Return a deferred call parameter.
505 -- Input parameters
506 -- callno
507 -- call identifier from the defCall view
508 -- arg_no
509 -- position of desired parameter in calls argument list
510 -- parameter positions are 1..number of parameters in call
511 -- deferred_tran_id
512 -- deferred transaction id, defaults to one passed in get_arg_type
513 ----
514 -- Result
515 -- The value of the parameter .
516 ------
517 -- EXCEPTIONS
518 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
519 -- queue tables.
520 -- WRONG_TYPE if the desired parameter is not interval day to second.
521 -------
522 FUNCTION get_object_null_vector_arg(
523 callno IN NUMBER,
524 arg_no IN NUMBER,
525 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
526 RETURN system.repcat$_object_null_vector;
527 -- Return a deferred call parameter.
528 -- Input parameters
529 -- callno
533 -- parameter positions are 1..number of parameters in call
530 -- call identifier from the defCall view
531 -- arg_no
532 -- position of desired parameter in calls argument list
534 -- deferred_tran_id
535 -- deferred transaction id, defaults to one passed in get_arg_type
536 ----
537 -- Result
538 -- The value of the parameter .
539 ------
540 -- EXCEPTIONS
541 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
542 -- queue tables.
543 -- WRONG_TYPE if the desired parameter is not an object_null_vector type
544 -------
545 FUNCTION get_anydata_arg(callno IN NUMBER,
546 arg_no IN NUMBER,
547 deferred_tran_id IN VARCHAR2 DEFAULT NULL)
548 RETURN Sys.AnyData;
549 -- Return a deferred call parameter.
550 -- Input parameters
551 -- callno
552 -- call identifier from the defCall view
553 -- arg_no
554 -- position of desired parameter in calls argument list
555 -- parameter positions are 1..number of parameters in call
556 -- deferred_tran_id
557 -- deferred transaction id, defaults to one passed in get_arg_type
558 ----
559 -- Result
560 -- The value of the parameter.
561 -- Notes
562 -- Supported types include Collections, Object types, REF types and
563 -- opaque types.
564 -- Not all types supported by get_anydata_arg can be enqueued
565 -- using anydata_arg.
566 ------
567 -- EXCEPTIONS
568 -- NO_DATA_FOUND desired parameter value not found in the deferred rpc
569 -- queue tables.
570 -- WRONG_TYPE if the desired parameter is not one of the types that
571 -- can be handled by anydata type
572 -------
573 PROCEDURE get_call_args
574 (
575 callno IN NUMBER, -- deferred call number
576 startarg IN NUMBER := 1, -- starting argument to fetch
577 argcnt IN NUMBER, -- number of arguments in the call
578 argsize IN NUMBER, -- maximum size of returned argument
579 tran_db IN VARCHAR2, -- origin database
580 tran_id IN VARCHAR2, -- transaction id
581 date_fmt IN VARCHAR2, -- date format
582 types OUT TYPE_ARY, -- output array for types
583 -- of the arguments
584 vals OUT VAL_ARY -- output array of the values
585 );
586 -- This procedure returns the text version of the various arguments for the
587 -- given call. The exceptions returned by this function are the same ones
588 -- as returned by get_arg_type and get _xxx_arg.
589 -- This is obsolete in V8.
590
591 PROCEDURE get_call_args
592 (
593 callno IN NUMBER, -- deferred call number
594 startarg IN NUMBER := 1, -- starting argument to fetch
595 argcnt IN NUMBER, -- number of arguments in the call
596 argsize IN NUMBER, -- maximum size of returned argument
597 tran_id IN VARCHAR2, -- transaction id
598 date_fmt IN VARCHAR2, -- date format
599 time_fmt IN VARCHAR2, -- time format
600 ttz_fmt IN VARCHAR2, -- time with time zone format
601 timestamp_fmt IN VARCHAR2, -- timestamp format
602 tstz_fmt IN VARCHAR2, -- timestamp with time zone format
603 types OUT TYPE_ARY, -- output array for types
604 -- of the arguments
605 forms OUT TYPE_ARY, -- output array for forms
606 -- of the arguments
607 vals OUT VAL_ARY -- output array of the values
608 );
609 -- This procedure returns the text version of the various arguments for the
610 -- given call. The exceptions returned by this function are the same ones
611 -- as returned by get_arg_type and get _xxx_arg.
612
613 PROCEDURE get_call_args
614 (
615 callno IN NUMBER, -- deferred call number
616 startarg IN NUMBER := 1, -- starting argument to fetch
617 argcnt IN NUMBER, -- number of arguments in the call
618 argsize IN NUMBER, -- maximum size of returned argument
619 tran_id IN VARCHAR2, -- transaction id
620 date_fmt IN VARCHAR2, -- date format
621 time_fmt IN VARCHAR2, -- time format
622 ttz_fmt IN VARCHAR2, -- time with time zone format
623 timestamp_fmt IN VARCHAR2, -- timestamp format
624 tstz_fmt IN VARCHAR2, -- timestamp with time zone format
625 tsltz_fmt IN VARCHAR2, -- timestamp with local timezone format
626 types OUT TYPE_ARY, -- output array for types
627 -- of the arguments
628 forms OUT TYPE_ARY, -- output array for forms
629 -- of the arguments
630 vals OUT VAL_ARY -- output array of the values
631 );
632 -- This procedure returns the text version of the various arguments for the
633 -- given call. The exceptions returned by this function are the same ones
634 -- as returned by get_arg_type and get _xxx_arg.
635
636 END dbms_defer_query;