[Home] [Help]
PACKAGE: CTXSYS.DRVLSB
Source
1 package drvlsb authid current_user as
2
3 /* value of maxtime_unlimited should be same as that present in dr0ddl */
4 MAXTIME_UNLIMITED constant number := 2147483647;
5
6 /* global values copied from dr0ddl.pkh */
7 LOCK_WAIT constant number := 0;
8 LOCK_NOWAIT constant number := 1;
9 LOCK_NOWAIT_ERROR constant number := 2;
10
11 /*------------------------- create_preference_c ---------------------------*/
12 procedure create_preference_c(
13 preference_name in varchar2,
14 object_name in varchar2,
15 preference_implicit_commit in boolean);
16 PRAGMA SUPPLEMENTAL_LOG_DATA(create_preference_c, AUTO_WITH_COMMIT);
17
18 /*------------------------- create_preference_nc --------------------------*/
19 procedure create_preference_nc(
20 preference_name in varchar2,
21 object_name in varchar2,
22 preference_implicit_commit in boolean);
23 PRAGMA SUPPLEMENTAL_LOG_DATA(create_preference_nc, AUTO);
24
25 /*-------------------------- drop_preference_c ---------------------------*/
26 procedure drop_preference_c(
27 preference_name in varchar2,
28 preference_implicit_commit in boolean);
29 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_preference_c, AUTO_WITH_COMMIT);
30
31 /*-------------------------- drop_preference_nc ---------------------------*/
32 procedure drop_preference_nc(
33 preference_name in varchar2,
34 preference_implicit_commit in boolean);
35 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_preference_nc, AUTO);
36
37 /*---------------------------- set_attribute ----------------------------*/
38 procedure set_attribute_c(
39 preference_name in varchar2,
40 attribute_name in varchar2,
41 attribute_value in varchar2,
42 preference_implicit_commit in boolean
43 );
44 PRAGMA SUPPLEMENTAL_LOG_DATA(set_attribute_c, AUTO_WITH_COMMIT);
45
46 procedure set_attribute_nc(
47 preference_name in varchar2,
48 attribute_name in varchar2,
49 attribute_value in varchar2,
50 preference_implicit_commit in boolean
51 );
52 PRAGMA SUPPLEMENTAL_LOG_DATA(set_attribute_nc, AUTO);
53
54 /*-------------------------- unset_attribute ----------------------------*/
55 procedure unset_attribute_c(
56 preference_name in varchar2,
57 attribute_name in varchar2,
58 preference_implicit_commit in boolean
59 );
60 PRAGMA SUPPLEMENTAL_LOG_DATA(unset_attribute_c, AUTO_WITH_COMMIT);
61
62 procedure unset_attribute_nc(
63 preference_name in varchar2,
64 attribute_name in varchar2,
65 preference_implicit_commit in boolean
66 );
67 PRAGMA SUPPLEMENTAL_LOG_DATA(unset_attribute_nc, AUTO);
68
69 /*-------------------- create_section_group ---------------------------*/
70 PROCEDURE create_section_group_c(
71 group_name in varchar2
72 , group_type in varchar2
73 , preference_implicit_commit in boolean
74 );
75 PRAGMA SUPPLEMENTAL_LOG_DATA(create_section_group_c, AUTO_WITH_COMMIT);
76
77 PROCEDURE create_section_group_nc(
78 group_name in varchar2
79 , group_type in varchar2
80 , preference_implicit_commit in boolean
81 );
82 PRAGMA SUPPLEMENTAL_LOG_DATA(create_section_group_nc, AUTO);
83
84 /*-------------------- drop_section_group ---------------------------*/
85 PROCEDURE drop_section_group_c(
86 group_name in varchar2
87 , preference_implicit_commit in boolean
88 );
89 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_section_group_c, AUTO_WITH_COMMIT);
90
91 PROCEDURE drop_section_group_nc(
92 group_name in varchar2
93 , preference_implicit_commit in boolean
94 );
95 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_section_group_nc, AUTO);
96
97 /*-------------------- add_zone_section ---------------------------*/
98 PROCEDURE add_zone_section_c(
99 group_name in varchar2,
100 section_name in varchar2,
101 tag in varchar2,
102 preference_implicit_commit in boolean
103 );
104 PRAGMA SUPPLEMENTAL_LOG_DATA(add_zone_section_c, AUTO_WITH_COMMIT);
105
106 PROCEDURE add_zone_section_nc(
107 group_name in varchar2,
108 section_name in varchar2,
109 tag in varchar2,
110 preference_implicit_commit in boolean
111 );
112 PRAGMA SUPPLEMENTAL_LOG_DATA(add_zone_section_nc, AUTO);
113
114 /*-------------------- add_field_section -------------------------*/
115 PROCEDURE add_field_section_c(
116 group_name in varchar2,
117 section_name in varchar2,
118 tag in varchar2,
119 visible in boolean default FALSE,
120 preference_implicit_commit in boolean
121 );
122 PRAGMA SUPPLEMENTAL_LOG_DATA(add_field_section_c, AUTO_WITH_COMMIT);
123
124 PROCEDURE add_field_section_nc(
125 group_name in varchar2,
126 section_name in varchar2,
127 tag in varchar2,
128 visible in boolean default FALSE,
129 preference_implicit_commit in boolean
130 );
131 PRAGMA SUPPLEMENTAL_LOG_DATA(add_field_section_nc, AUTO);
132
133 /*-------------------- add_special_section -------------------------*/
134 PROCEDURE add_special_section_c(
135 group_name in varchar2,
136 section_name in varchar2,
137 preference_implicit_commit in boolean
138 );
139 PRAGMA SUPPLEMENTAL_LOG_DATA(add_special_section_c, AUTO_WITH_COMMIT);
140
141 PROCEDURE add_special_section_nc(
142 group_name in varchar2,
143 section_name in varchar2,
144 preference_implicit_commit in boolean
145 );
146 PRAGMA SUPPLEMENTAL_LOG_DATA(add_special_section_nc, AUTO);
147
148 /*-------------------- add_stop_section -----------------------------*/
149 PROCEDURE add_stop_section_c(
150 group_name in varchar2
151 , tag in varchar2
152 , preference_implicit_commit in boolean
153 );
154 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stop_section_c, AUTO_WITH_COMMIT);
155
156 PROCEDURE add_stop_section_nc(
157 group_name in varchar2
158 , tag in varchar2
159 , preference_implicit_commit in boolean
160 );
161 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stop_section_nc, AUTO);
162
163 /*-------------------- add_attr_section -----------------------------*/
164 PROCEDURE add_attr_section_c(
165 group_name in varchar2
166 , section_name in varchar2
167 , tag in varchar2
168 , preference_implicit_commit in boolean
169 );
170 PRAGMA SUPPLEMENTAL_LOG_DATA(add_attr_section_c, AUTO_WITH_COMMIT);
171
172 PROCEDURE add_attr_section_nc(
173 group_name in varchar2
174 , section_name in varchar2
175 , tag in varchar2
176 , preference_implicit_commit in boolean
177 );
178 PRAGMA SUPPLEMENTAL_LOG_DATA(add_attr_section_nc, AUTO);
179
180 /*-------------------- add_xml_section -----------------------------*/
181 PROCEDURE add_xml_section_c(
182 group_name in varchar2
183 , tag in varchar2
184 , preference_implicit_commit in boolean
185 );
186 PRAGMA SUPPLEMENTAL_LOG_DATA(add_xml_section_c, AUTO_WITH_COMMIT);
187
188 PROCEDURE add_xml_section_nc(
189 group_name in varchar2
190 , tag in varchar2
191 , preference_implicit_commit in boolean
192 );
193 PRAGMA SUPPLEMENTAL_LOG_DATA(add_xml_section_nc, AUTO);
194
195 /*-------------------- add_mdata_section -----------------------------*/
196 PROCEDURE add_mdata_section_c(
197 group_name in varchar2,
198 section_name in varchar2,
199 tag in varchar2,
200 read_only in boolean default FALSE,
201 preference_implicit_commit in boolean
202 );
203 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata_section_c, AUTO_WITH_COMMIT);
204
205 PROCEDURE add_mdata_section_nc(
206 group_name in varchar2,
207 section_name in varchar2,
208 tag in varchar2,
209 read_only in boolean default FALSE,
210 preference_implicit_commit in boolean
211 );
212 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata_section_nc, AUTO);
213
214 /*-------------------- add_ndata_section -----------------------------*/
215 PROCEDURE add_ndata_section_c(
216 group_name in varchar2,
217 section_name in varchar2,
218 tag in varchar2,
219 preference_implicit_commit in boolean
220 );
221 PRAGMA SUPPLEMENTAL_LOG_DATA(add_ndata_section_c, AUTO_WITH_COMMIT);
222
223 PROCEDURE add_ndata_section_nc(
224 group_name in varchar2,
225 section_name in varchar2,
226 tag in varchar2,
227 preference_implicit_commit in boolean
228 );
229 PRAGMA SUPPLEMENTAL_LOG_DATA(add_ndata_section_nc, AUTO);
230
231 /*-------------------- add_mvdata_section -----------------------------*/
232 PROCEDURE add_mvdata_section_c(
233 group_name in varchar2,
234 section_name in varchar2,
235 tag in varchar2,
236 datatype in varchar2 default NULL,
237 preference_implicit_commit in boolean
238 );
239 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mvdata_section_c, AUTO_WITH_COMMIT);
240
241 PROCEDURE add_mvdata_section_nc(
242 group_name in varchar2,
243 section_name in varchar2,
244 tag in varchar2,
245 datatype in varchar2 default NULL,
246 preference_implicit_commit in boolean
247 );
248 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mvdata_section_nc, AUTO);
249
250 /*-------------------- add_sdata_section -----------------------------*/
251 PROCEDURE add_sdata_section_c(
252 group_name in varchar2,
253 section_name in varchar2,
254 tag in varchar2,
255 datatype in varchar2 default NULL,
256 preference_implicit_commit in boolean
257 );
258 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sdata_section_c, AUTO_WITH_COMMIT);
259
260 PROCEDURE add_sdata_section_nc(
261 group_name in varchar2,
262 section_name in varchar2,
263 tag in varchar2,
264 datatype in varchar2 default NULL,
265 preference_implicit_commit in boolean
266 );
267 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sdata_section_nc, AUTO);
268
269 /*-------------------- add_sdata_column -----------------------------*/
270
271 PROCEDURE add_sdata_column_c(
272 group_name in varchar2,
273 section_name in varchar2,
274 column_name in varchar2,
275 preference_implicit_commit in boolean
276 );
277 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sdata_column_c, AUTO_WITH_COMMIT);
278
279 PROCEDURE add_sdata_column_nc(
280 group_name in varchar2,
281 section_name in varchar2,
282 column_name in varchar2,
283 preference_implicit_commit in boolean
284 );
285 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sdata_column_nc, AUTO);
286
287 PROCEDURE add_mdata_column_c(
288 group_name in varchar2,
289 section_name in varchar2,
290 column_name in varchar2,
291 preference_implicit_commit in boolean
292 );
293 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata_column_c, AUTO_WITH_COMMIT);
294
295 PROCEDURE add_mdata_column_nc(
296 group_name in varchar2,
297 section_name in varchar2,
298 column_name in varchar2,
299 preference_implicit_commit in boolean
300 );
301 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata_column_nc, AUTO);
302
303 /*-------------------- remove_section ---------------------------*/
304
305 PROCEDURE remove_section_c(
306 group_name in varchar2,
307 section_name in varchar2,
308 preference_implicit_commit in boolean
309 );
310 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_section_c, AUTO_WITH_COMMIT);
311
312 PROCEDURE remove_section_nc(
313 group_name in varchar2,
314 section_name in varchar2,
315 preference_implicit_commit in boolean
316 );
317 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_section_nc, AUTO);
318
319 PROCEDURE remove_section_c(
320 group_name in varchar2,
321 section_id in number,
322 preference_implicit_commit in boolean
323 );
324 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_section_c, AUTO_WITH_COMMIT);
325
326 PROCEDURE remove_section_nc(
327 group_name in varchar2,
328 section_id in number,
329 preference_implicit_commit in boolean
330 );
331 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_section_nc, AUTO);
332
333 /*-------------------- create_stoplist --------------------------*/
334
335 PROCEDURE create_stoplist_c(
336 stoplist_name in varchar2,
337 stoplist_type in varchar2 default 'BASIC_STOPLIST',
341
338 preference_implicit_commit in boolean
339 );
340 PRAGMA SUPPLEMENTAL_LOG_DATA(create_stoplist_c, AUTO_WITH_COMMIT);
342 PROCEDURE create_stoplist_nc(
343 stoplist_name in varchar2,
344 stoplist_type in varchar2 default 'BASIC_STOPLIST',
345 preference_implicit_commit in boolean
346 );
347 PRAGMA SUPPLEMENTAL_LOG_DATA(create_stoplist_nc, AUTO);
348
349 /*-------------------- drop_stoplist --------------------------*/
350
351 PROCEDURE drop_stoplist_c(
352 stoplist_name in varchar2,
353 preference_implicit_commit in boolean
354 );
355 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_stoplist_c, AUTO_WITH_COMMIT);
356
357 PROCEDURE drop_stoplist_nc(
358 stoplist_name in varchar2,
359 preference_implicit_commit in boolean
360 );
361 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_stoplist_nc, AUTO);
362
363 /*-------------------- add_stopword --------------------------*/
364
365 PROCEDURE add_stopword_c(
366 stoplist_name in varchar2,
367 stopword in varchar2,
368 language in varchar2 default NULL,
369 language_dependent in boolean default TRUE,
370 preference_implicit_commit in boolean
371 );
372 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stopword_c, AUTO_WITH_COMMIT);
373
374 PROCEDURE add_stopword_nc(
375 stoplist_name in varchar2,
376 stopword in varchar2,
377 language in varchar2 default NULL,
378 language_dependent in boolean default TRUE,
379 preference_implicit_commit in boolean
380 );
381 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stopword_nc, AUTO);
382
383 /*-------------------- add_stoptheme --------------------------*/
384
385 PROCEDURE add_stoptheme_c(
386 stoplist_name in varchar2,
387 stoptheme in varchar2,
388 preference_implicit_commit in boolean
389 );
390 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stoptheme_c, AUTO_WITH_COMMIT);
391
392 PROCEDURE add_stoptheme_nc(
393 stoplist_name in varchar2,
394 stoptheme in varchar2,
395 preference_implicit_commit in boolean
396 );
397 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stoptheme_nc, AUTO);
398
399 /*-------------------- add_stopclass --------------------------*/
400
401 PROCEDURE add_stopclass_c(
402 stoplist_name in varchar2,
403 stopclass in varchar2,
404 stoppattern in varchar2 default NULL,
405 preference_implicit_commit in boolean
406 );
407 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stopclass_c, AUTO_WITH_COMMIT);
408
409 PROCEDURE add_stopclass_nc(
410 stoplist_name in varchar2,
411 stopclass in varchar2,
412 stoppattern in varchar2 default NULL,
413 preference_implicit_commit in boolean
414 );
415 PRAGMA SUPPLEMENTAL_LOG_DATA(add_stopclass_nc, AUTO);
416
417 /*-------------------- add_index ---------------------------*/
418
419 PROCEDURE add_index_c(
420 set_name in varchar2,
421 column_list in varchar2,
422 storage_clause in varchar2 default null,
423 preference_implicit_commit in boolean
424 );
425 PRAGMA SUPPLEMENTAL_LOG_DATA(add_index_c, AUTO_WITH_COMMIT);
426
427 PROCEDURE add_index_nc(
428 set_name in varchar2,
429 column_list in varchar2,
430 storage_clause in varchar2 default null,
431 preference_implicit_commit in boolean
432 );
433 PRAGMA SUPPLEMENTAL_LOG_DATA(add_index_nc, AUTO);
434
435 /*-------------------- create_index_set ---------------------------*/
436
437 PROCEDURE create_index_set_c(
438 set_name in varchar2,
439 preference_implicit_commit in boolean
440 );
441 PRAGMA SUPPLEMENTAL_LOG_DATA(create_index_set_c, AUTO_WITH_COMMIT);
442
443 PROCEDURE create_index_set_nc(
444 set_name in varchar2,
445 preference_implicit_commit in boolean
446 );
447 PRAGMA SUPPLEMENTAL_LOG_DATA(create_index_set_nc, AUTO);
448
449 /*-------------------- remove_index ---------------------------*/
450 PROCEDURE remove_index_c(
451 set_name in varchar2,
452 column_list in varchar2,
453 preference_implicit_commit in boolean
454 );
455 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_index_c, AUTO_WITH_COMMIT);
456
457 PROCEDURE remove_index_nc(
458 set_name in varchar2,
459 column_list in varchar2,
460 preference_implicit_commit in boolean
461 );
462 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_index_nc, AUTO);
463
464 /*-------------------- add_sub_lexer ---------------------------*/
465
466 PROCEDURE add_sub_lexer_c(
467 lexer_name in varchar2,
468 language in varchar2,
469 sub_lexer in varchar2,
470 alt_value in varchar2 default NULL,
471 language_dependent in boolean default TRUE,
472 preference_implicit_commit in boolean
473 );
474 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sub_lexer_c, AUTO_WITH_COMMIT);
475
476 PROCEDURE add_sub_lexer_nc(
477 lexer_name in varchar2,
478 language in varchar2,
479 sub_lexer in varchar2,
480 alt_value in varchar2 default NULL,
481 language_dependent in boolean default TRUE,
482 preference_implicit_commit in boolean
483 );
484 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sub_lexer_nc, AUTO);
485
486 /*-------------------- remove_sub_lexer ---------------------------*/
487
488 PROCEDURE remove_sub_lexer_c(
489 lexer_name in varchar2,
490 language in varchar2,
491 preference_implicit_commit in boolean
492 );
493 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_sub_lexer_c, AUTO_WITH_COMMIT);
494
495 PROCEDURE remove_sub_lexer_nc(
496 lexer_name in varchar2,
497 language in varchar2,
498 preference_implicit_commit in boolean
502 /*-------------------- update_sub_lexer ---------------------------*/
499 );
500 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_sub_lexer_nc, AUTO);
501
503
504 PROCEDURE update_sub_lexer_c(
505 lexer_name in varchar2,
506 language in varchar2,
507 sub_lexer in varchar2,
508 preference_implicit_commit in boolean
509 );
510 PRAGMA SUPPLEMENTAL_LOG_DATA(update_sub_lexer_c, AUTO_WITH_COMMIT);
511
512 PROCEDURE update_sub_lexer_nc(
513 lexer_name in varchar2,
514 language in varchar2,
515 sub_lexer in varchar2,
516 preference_implicit_commit in boolean
517 );
518 PRAGMA SUPPLEMENTAL_LOG_DATA(update_sub_lexer_nc, AUTO);
519
520 /*-------------------- update_sub_lexer ---------------------------*/
521
522 procedure set_section_attribute_c(group_name in varchar2,
523 section_name in varchar2,
524 attribute_name in varchar2,
525 attribute_value in varchar2,
526 preference_implicit_commit in boolean);
527 PRAGMA SUPPLEMENTAL_LOG_DATA(set_section_attribute_c, AUTO_WITH_COMMIT);
528
529 procedure set_section_attribute_nc(group_name in varchar2,
530 section_name in varchar2,
531 attribute_name in varchar2,
532 attribute_value in varchar2,
533 preference_implicit_commit in boolean);
534 PRAGMA SUPPLEMENTAL_LOG_DATA(set_section_attribute_nc, AUTO);
535
536 /*-------------------------- unset_section_attribute -----------------------*/
537 procedure unset_section_attribute_c(group_name in varchar2,
538 section_name in varchar2,
539 attribute_name in varchar2,
540 preference_implicit_commit in boolean);
541 PRAGMA SUPPLEMENTAL_LOG_DATA(unset_section_attribute_c, AUTO_WITH_COMMIT);
542
543 procedure unset_section_attribute_nc(group_name in varchar2,
544 section_name in varchar2,
545 attribute_name in varchar2,
546 preference_implicit_commit in boolean);
547 PRAGMA SUPPLEMENTAL_LOG_DATA(unset_section_attribute_nc, AUTO);
548
549 /* hard procedures with rowid argument */
550
551 /*-------------------------- add_mdata ---------------------------*/
552 PROCEDURE add_mdata(
553 idx_name in varchar2,
554 section_name in varchar2,
555 mdata_value in varchar2,
556 mdata_pkencode in varchar2,
557 part_name in varchar2 default null
558 );
559 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata, AUTO);
560
561 PROCEDURE add_mdata(
562 idx_name in varchar2,
563 section_name in varchar2,
564 mdata_values in sys.odcivarchar2list,
565 mdata_pkencodes in sys.odcivarchar2list,
566 part_name in varchar2 default null
567 );
568 PRAGMA SUPPLEMENTAL_LOG_DATA(add_mdata, AUTO);
569
570 /*-------------------------- remove_mdata ---------------------------*/
571 PROCEDURE remove_mdata(
572 idx_name in varchar2,
573 section_name in varchar2,
574 mdata_value in varchar2,
575 mdata_pkencode in varchar2,
576 part_name in varchar2 default null
577 );
578 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_mdata, AUTO);
579
580 PROCEDURE remove_mdata(
581 idx_name in varchar2,
582 section_name in varchar2,
583 mdata_values in sys.odcivarchar2list,
584 mdata_pkencodes in sys.odcivarchar2list,
585 part_name in varchar2 default null
586 );
587 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_mdata, AUTO);
588
589 /*---------------------- insert_mvdata_values ------------------------------*/
590 PROCEDURE insert_mvdata_values(
591 idx_name in varchar2 default NULL,
592 section_name in varchar2 default NULL,
593 mvdata_values in sys.odcinumberlist,
594 mvdata_pkencodes in sys.odcivarchar2list,
595 part_name in varchar2 default NULL
596 );
597 PRAGMA SUPPLEMENTAL_LOG_DATA(insert_mvdata_values, AUTO);
598
599 /*---------------------- delete_mvdata_values ------------------------------*/
600 PROCEDURE delete_mvdata_values(
601 idx_name in varchar2 default NULL,
602 section_name in varchar2 default NULL,
603 mvdata_values in sys.odcinumberlist,
604 mvdata_pkencodes in sys.odcivarchar2list,
605 part_name in varchar2 default NULL
606 );
607 PRAGMA SUPPLEMENTAL_LOG_DATA(delete_mvdata_values, AUTO);
608
609 /*---------------------- add_sdata ------------------------------*/
610 PROCEDURE add_sdata(
611 idx_name in varchar2,
612 section_name in varchar2,
613 sdata_value in varchar2,
614 sdata_pkencode in rowid,
615 part_name in varchar2 default null
616 );
617 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sdata, AUTO);
618
619 /*---------------------- delete_sdata ------------------------------*/
620 PROCEDURE remove_sdata(
621 idx_name in varchar2,
622 section_name in varchar2,
623 sdata_value in varchar2,
624 sdata_pkencode in rowid,
625 part_name in varchar2 default null
626 );
627 PRAGMA SUPPLEMENTAL_LOG_DATA(remove_sdata, AUTO);
628
629 /*---------------------- update_mvdata_set ------------------------------*/
630 PROCEDURE update_mvdata_set(
631 idx_name in varchar2 default NULL,
632 section_name in varchar2 default NULL,
633 mvdata_values in sys.odcinumberlist,
634 mvdata_pkencodes in sys.odcivarchar2list,
638
635 part_name in varchar2 default NULL
636 );
637 PRAGMA SUPPLEMENTAL_LOG_DATA(update_mvdata_set, AUTO);
639 /*---------------------- update_sdata ------------------------------*/
640 PROCEDURE update_sdata(
641 idx_name in varchar2,
642 section_name in varchar2,
643 sdata_value in sys.anydata,
644 sdata_pkencode in rowid,
645 part_name in varchar2 default NULL
646 );
647 PRAGMA SUPPLEMENTAL_LOG_DATA(update_sdata, AUTO);
648
649 /*--------------------------- populate_pending ----------------------------*/
650 PROCEDURE populate_pending(
651 idx_name in varchar2,
652 part_name in varchar2,
653 rio in boolean,
654 idx_suffix in varchar2
655 );
656 PRAGMA SUPPLEMENTAL_LOG_DATA(populate_pending, AUTO);
657
658 /*------------------------- recreate_index_online ------------------------*/
659 PROCEDURE recreate_index_online(
660 idx_name in varchar2,
661 parameter_string in varchar2,
662 parallel_degree in number,
663 partition_name in varchar2,
664 rio in boolean,
665 idx_suffix in varchar2
666 );
667 PRAGMA SUPPLEMENTAL_LOG_DATA(recreate_index_online, AUTO);
668
669 /*----------------------- create_shadow_index ---------------------*/
670 PROCEDURE create_shadow_index(
671 idx_name in varchar2,
672 parameter_string in varchar2,
673 parallel_degree in number,
674 rio in boolean,
675 idx_suffix in varchar2
676 );
677 PRAGMA SUPPLEMENTAL_LOG_DATA(create_shadow_index, AUTO);
678
679 /*----------------------- exchange_shadow_index ---------------------*/
680 PROCEDURE exchange_shadow_index(
681 idx_name in varchar2,
682 partition_name in varchar2,
683 rio in boolean,
684 idx_suffix in varchar2
685 );
686 PRAGMA SUPPLEMENTAL_LOG_DATA(exchange_shadow_index, AUTO);
687
688 /*----------------------- drop_shadow_index ---------------------*/
689 procedure drop_shadow_index(
690 idx_name varchar2,
691 rio in boolean,
692 idx_suffix in varchar2
693 );
694 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_shadow_index, AUTO);
695
696 /*--------------------------- sync_index ----------------------------*/
697 PROCEDURE sync_index(
698 idx_name in varchar2,
699 memory in varchar2,
700 part_name in varchar2,
701 parallel_degree in number,
702 maxtime in number,
703 locking in number,
704 direct_path in boolean,
705 rio in boolean,
706 idx_suffix in varchar2
707 );
708 PRAGMA SUPPLEMENTAL_LOG_DATA(sync_index, AUTO);
709
710 /*--------------------------- optimize_index ----------------------------*/
711 PROCEDURE optimize_index(
712 idx_name in varchar2,
713 optlevel in varchar2,
714 maxtime in number,
715 token in varchar2,
716 part_name in varchar2,
717 token_type in number,
718 parallel_degree in number,
719 memory in varchar2,
720 background in boolean,
721 rio in boolean,
722 idx_suffix in varchar2
723 );
724 PRAGMA SUPPLEMENTAL_LOG_DATA(optimize_index, AUTO);
725
726 /*----------------------------- filter ----------------------------------*/
727 PROCEDURE filter (
728 index_name in varchar2,
729 textkey in varchar2,
730 restab in varchar2,
731 query_id in number default 0,
732 plaintext in boolean default FALSE,
733 use_saved_copy in number
734 );
735 PRAGMA SUPPLEMENTAL_LOG_DATA(filter, AUTO);
736
737 /*----------------------------- gist -----------------------------------*/
738 PROCEDURE gist (
739 index_name in varchar2,
740 textkey in varchar2,
741 restab in varchar2,
742 query_id in number default 0,
743 glevel in varchar2 default 'P',
744 pov in varchar2 default null,
745 numParagraphs in number default null,
746 maxPercent in number default null,
747 num_themes in number default 50,
748 use_saved_copy in number
749 );
750 PRAGMA SUPPLEMENTAL_LOG_DATA(gist, AUTO);
751
752 /*----------------------------- markup -----------------------------------*/
753 PROCEDURE markup (
754 index_name in varchar2,
755 textkey in varchar2,
756 text_query in varchar2,
757 restab in varchar2,
758 query_id in number default 0,
759 plaintext in boolean default FALSE,
760 tagset in varchar2 default 'TEXT_DEFAULT',
761 starttag in varchar2 default null,
762 endtag in varchar2 default null,
763 prevtag in varchar2 default null,
764 nexttag in varchar2 default null,
765 use_saved_copy in number
766 );
767 PRAGMA SUPPLEMENTAL_LOG_DATA(markup, AUTO);
768
769 /*----------------------------- tokens -----------------------------------*/
770 PROCEDURE tokens (
771 index_name in varchar2,
772 textkey in varchar2,
773 restab in varchar2,
774 query_id in number default 0,
775 use_saved_copy in number
776 );
777 PRAGMA SUPPLEMENTAL_LOG_DATA(tokens, AUTO);
778
779 /*----------------------------- themes -----------------------------------*/
780 PROCEDURE themes (
781 index_name in varchar2,
782 textkey in varchar2,
783 restab in varchar2,
784 query_id in number default 0,
785 full_themes in boolean default false,
786 num_themes in number default 50,
787 use_saved_copy in number,
788 pv_reslob in out nocopy clob
789 );
790 PRAGMA SUPPLEMENTAL_LOG_DATA(themes, AUTO);
791
792 /*----------------------------- highlight -----------------------------------*/
793 PROCEDURE highlight (
794 index_name in varchar2,
795 textkey in varchar2,
796 text_query in varchar2,
797 restab in varchar2,
798 query_id in number default 0,
799 plaintext in boolean default FALSE,
800 use_saved_copy in number,
801 pv_reslob in out nocopy clob
802 );
803 PRAGMA SUPPLEMENTAL_LOG_DATA(highlight, AUTO);
804
805 /*--------------------------- markup_clob_query -----------------------------*/
806 PROCEDURE markup_clob_query (
807 index_name in varchar2,
808 textkey in varchar2,
809 text_query in clob,
810 restab in varchar2,
811 query_id in number default 0,
812 plaintext in boolean default FALSE,
813 tagset in varchar2 default 'TEXT_DEFAULT',
814 starttag in varchar2 default null,
815 endtag in varchar2 default null,
816 prevtag in varchar2 default null,
817 nexttag in varchar2 default null,
818 use_saved_copy in number
819 );
820 PRAGMA SUPPLEMENTAL_LOG_DATA(markup_clob_query, AUTO);
821
822 /*------------------------- highlight_clob_query --------------------------*/
823 PROCEDURE highlight_clob_query (
824 index_name in varchar2,
825 textkey in varchar2,
826 text_query in clob,
827 restab in varchar2,
828 query_id in number default 0,
829 plaintext in boolean default FALSE,
830 use_saved_copy in number,
831 pv_reslob in out nocopy clob
832 );
833 PRAGMA SUPPLEMENTAL_LOG_DATA(highlight_clob_query, AUTO);
834
835 /*----------------------- add_dictionary -----------------------*/
836 PROCEDURE add_dictionary_c(name in VARCHAR2,
837 language in VARCHAR2,
838 dictionary in CLOB,
839 preference_implicit_commit in boolean);
840 PRAGMA SUPPLEMENTAL_LOG_DATA(add_dictionary_c, AUTO_WITH_COMMIT);
841
842 PROCEDURE add_dictionary_nc(name in VARCHAR2,
843 language in VARCHAR2,
844 dictionary in CLOB,
845 preference_implicit_commit in boolean);
846 PRAGMA SUPPLEMENTAL_LOG_DATA(add_dictionary_nc, AUTO);
847
848 /*----------------------- drop_dictionary ----------------------*/
849 PROCEDURE drop_dictionary_c(name in VARCHAR2,
850 preference_implicit_commit in boolean);
851 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_dictionary_c, AUTO_WITH_COMMIT);
852
853 PROCEDURE drop_dictionary_nc(name in VARCHAR2,
854 preference_implicit_commit in boolean);
855 PRAGMA SUPPLEMENTAL_LOG_DATA(drop_dictionary_nc, AUTO);
856
857 /*-------------------------- set_sec_grp_attr -------------------*/
858 procedure set_sec_grp_attr_c(group_name in varchar2,
859 attribute_name in varchar2,
860 attribute_value in varchar2);
861 PRAGMA SUPPLEMENTAL_LOG_DATA(set_sec_grp_attr_c, AUTO_WITH_COMMIT);
862
863 procedure set_sec_grp_attr_nc(group_name in varchar2,
864 attribute_name in varchar2,
865 attribute_value in varchar2);
866 PRAGMA SUPPLEMENTAL_LOG_DATA(set_sec_grp_attr_nc, AUTO);
867
868 /*---------------------- add_sec_grp_attr_val -------------------*/
869 procedure add_sec_grp_attr_val_c(group_name in varchar2,
870 attribute_name in varchar2,
871 attribute_value in varchar2);
872 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sec_grp_attr_val_c, AUTO_WITH_COMMIT);
873
874 procedure add_sec_grp_attr_val_nc(group_name in varchar2,
875 attribute_name in varchar2,
876 attribute_value in varchar2);
877 PRAGMA SUPPLEMENTAL_LOG_DATA(add_sec_grp_attr_val_nc, AUTO);
878
879 /* helper functions */
880
881 /*------------------------- pk_exists --------------------------*/
882 FUNCTION pk_exists(
883 idx_name in varchar2
884 ) return boolean;
885
886 /*------------------------- get_pkencode --------------------------*/
887 PROCEDURE get_pkencode(
888 idx_name in varchar2,
889 rid in rowid,
890 pk_encode in out varchar2
891 );
892
893 end drvlsb;