-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathapex-plugin-clob-load.sql
520 lines (520 loc) · 39.3 KB
/
apex-plugin-clob-load.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
set define off verify off feedback off
whenever sqlerror exit sql.sqlcode rollback
--------------------------------------------------------------------------------
--
-- ORACLE Application Express (APEX) export file
--
-- You should run the script connected to SQL*Plus as the Oracle user
-- APEX_050000 or as the owner (parsing schema) of the application.
--
-- NOTE: Calls to apex_application_install override the defaults below.
--
--------------------------------------------------------------------------------
begin
wwv_flow_api.import_begin (
p_version_yyyy_mm_dd=>'2013.01.01'
,p_release=>'5.0.0.00.31'
,p_default_workspace_id=>11694666987526096
,p_default_application_id=>123
,p_default_owner=>'TEST1'
);
end;
/
prompt --application/ui_types
begin
null;
end;
/
prompt --application/shared_components/plugins/dynamic_action/apex_clob_load
begin
wwv_flow_api.create_plugin(
p_id=>wwv_flow_api.id(32500181608295300285)
,p_plugin_type=>'DYNAMIC ACTION'
,p_name=>'APEX_CLOB_LOAD'
,p_display_name=>'APEX CLOB Load'
,p_category=>'MISC'
,p_supported_ui_types=>'DESKTOP'
,p_javascript_file_urls=>'#PLUGIN_FILES#apex-clob-load.js'
,p_plsql_code=>wwv_flow_utilities.join(wwv_flow_t_varchar2(
'FUNCTION apex_clob_load_render (',
' p_dynamic_action IN APEX_PLUGIN.T_DYNAMIC_ACTION,',
' p_plugin IN APEX_PLUGIN.T_PLUGIN',
')',
'',
' RETURN APEX_PLUGIN.T_DYNAMIC_ACTION_RENDER_RESULT',
'',
'IS',
'',
' l_retval APEX_PLUGIN.T_DYNAMIC_ACTION_RENDER_RESULT;',
' l_action VARCHAR2(10) := NVL(p_dynamic_action.attribute_01, ''RENDER'');',
' l_change_only VARCHAR2(1) := NVL(p_dynamic_action.attribute_06, ''Y'');',
' l_make_blocking VARCHAR2(1) := NVL(p_dynamic_action.attribute_07, ''Y'');',
' l_show_spinner VARCHAR2(1) := NVL(p_dynamic_action.attribute_08, ''Y'');',
' l_crlf VARCHAR2(2) := CHR(13)||CHR(10);',
' l_js_function VARCHAR2(32767);',
' l_onload_code VARCHAR2(32767);',
'',
'BEGIN',
'',
' IF apex_application.g_debug',
' THEN',
' apex_plugin_util.debug_dynamic_action(',
' p_plugin => p_plugin,',
' p_dynamic_action => p_dynamic_action',
' );',
' END IF;',
'',
' l_onload_code :=',
' ''apex.jQuery(document).apexClobLoad({''|| l_crlf ||',
' '' pluginFilePrefix: "'' || p_plugin.file_prefix || ''"'' || l_crlf ||',
' ''});'';',
'',
' apex_javascript.add_onload_code(',
' p_code => l_onload_code',
' );',
'',
' IF l_action = ''RENDER''',
' THEN',
' l_js_function :=',
' ''function(){''|| l_crlf ||',
' '' apex.jQuery(document).apexClobLoad("renderClob", {'' || l_crlf ||',
' '' $elmt: this.affectedElements.eq(0),'' || l_crlf ||',
' '' ajaxIdentifier: "'' || apex_plugin.get_ajax_identifier() || ''",'' || l_crlf ||',
' '' showSpinner: "'' || l_show_spinner || ''"'' || l_crlf ||',
' '' });''|| l_crlf ||',
' ''}'';',
' ELSE',
' l_js_function :=',
' ''function(){''|| l_crlf ||',
' '' apex.jQuery(document).apexClobLoad("submitClob", {'' || l_crlf ||',
' '' $elmt: this.affectedElements.eq(0),'' || l_crlf ||',
' '' ajaxIdentifier: "'' || apex_plugin.get_ajax_identifier() || ''",'' || l_crlf ||',
' '' changeOnly: "'' || l_change_only || ''",'' || l_crlf ||',
' '' makeBlocking: "'' || l_make_blocking || ''",'' || l_crlf ||',
' '' showSpinner: "'' || l_show_spinner || ''"'' || l_crlf ||',
' '' });''|| l_crlf ||',
' ''}'';',
' END IF;',
'',
' l_retval.javascript_function := l_js_function;',
'',
' RETURN l_retval;',
'',
'END apex_clob_load_render;',
'',
'FUNCTION apex_clob_load_ajax (',
' p_dynamic_action IN APEX_PLUGIN.T_DYNAMIC_ACTION,',
' p_plugin IN APEX_PLUGIN.T_PLUGIN',
')',
'',
' RETURN APEX_PLUGIN.T_DYNAMIC_ACTION_AJAX_RESULT',
'',
'IS',
'',
' l_retval APEX_PLUGIN.T_DYNAMIC_ACTION_AJAX_RESULT;',
' l_ajax_function VARCHAR2(32767) := apex_application.g_x01;',
' l_source VARCHAR2(20) := NVL(p_dynamic_action.attribute_02, ''COLLECTION'');',
' l_render_collection_name VARCHAR2(255) := p_dynamic_action.attribute_03;',
' l_query VARCHAR2(32767) := p_dynamic_action.attribute_04;',
' l_submit_collection_name VARCHAR2(255) := p_dynamic_action.attribute_05;',
' l_column_value_list APEX_PLUGIN_UTIL.T_COLUMN_VALUE_LIST2;',
' l_clob_text CLOB := EMPTY_CLOB();',
' l_token VARCHAR2(32000);',
' l_chunk_size NUMBER := 4000;',
'',
'BEGIN',
'',
' IF l_ajax_function = ''RENDER_CLOB''',
' THEN',
' IF l_source = ''COLLECTION''',
' THEN',
' IF apex_collection.collection_exists(l_render_collection_name)',
' THEN',
' SELECT clob001',
' INTO l_clob_text',
' FROM apex_collections',
' WHERE collection_name = l_render_collection_name',
' AND seq_id = 1;',
' END IF;',
' ELSE --must be SQL_QUERY',
' BEGIN',
'',
' l_column_value_list := apex_plugin_util.get_data2(',
' p_sql_statement => l_query,',
' p_min_columns => 1,',
' p_max_columns => 1,',
' p_component_name => p_dynamic_action.action,',
' p_first_row => 1,',
' p_max_rows => 1',
' );',
'',
' EXCEPTION',
'',
' WHEN NO_DATA_FOUND',
' THEN',
' NULL;',
'',
' END;',
'',
' IF l_column_value_list.exists(1)',
' AND l_column_value_list(1).value_list.exists(1)',
' THEN',
' l_clob_text := l_column_value_list(1).value_list(1).clob_value;',
' END IF;',
' END IF;',
' ',
' IF LENGTH(l_clob_text) > 0',
' THEN',
' FOR i IN 0 .. FLOOR(LENGTH(l_clob_text)/l_chunk_size)',
' LOOP',
' sys.htp.prn(substr(l_clob_text, i * l_chunk_size + 1, l_chunk_size));',
' END LOOP;',
' END IF;',
' ELSE --must be SUBMIT_CLOB',
' dbms_lob.createtemporary(l_clob_text, false, dbms_lob.session);',
'',
' FOR i IN 1..apex_application.g_f01.count',
' LOOP',
' l_token := wwv_flow.g_f01(i);',
'',
' IF length(l_token) > 0',
' THEN',
' dbms_lob.writeappend(l_clob_text, length(l_token), l_token);',
' END IF;',
' END LOOP;',
'',
' apex_collection.create_or_truncate_collection(',
' p_collection_name => l_submit_collection_name',
' );',
'',
' apex_collection.add_member(',
' p_collection_name => l_submit_collection_name,',
' p_clob001 => l_clob_text',
' );',
' END IF;',
'',
' RETURN l_retval;',
'',
'END apex_clob_load_ajax;'))
,p_render_function=>'apex_clob_load_render'
,p_ajax_function=>'apex_clob_load_ajax'
,p_standard_attributes=>'ITEM:JQUERY_SELECTOR:REQUIRED'
,p_substitute_attributes=>true
,p_subscribe_plugin_settings=>true
,p_help_text=>'https://github.com/OraOpenSource/apex-plugin-clob-load'
,p_version_identifier=>'2017.08.04'
,p_about_url=>'https://github.com/OraOpenSource/apex-plugin-clob-load'
,p_files_version=>65
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500185262263300294)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>1
,p_display_sequence=>10
,p_prompt=>'CLOB Action'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>false
,p_default_value=>'RENDER'
,p_is_translatable=>false
,p_lov_type=>'STATIC'
);
wwv_flow_api.create_plugin_attr_value(
p_id=>wwv_flow_api.id(32500185792340300295)
,p_plugin_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_display_sequence=>10
,p_display_value=>'Render'
,p_return_value=>'RENDER'
);
wwv_flow_api.create_plugin_attr_value(
p_id=>wwv_flow_api.id(32500186348754300295)
,p_plugin_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_display_sequence=>20
,p_display_value=>'Submit'
,p_return_value=>'SUBMIT'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500186868469300295)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>2
,p_display_sequence=>20
,p_prompt=>'Source'
,p_attribute_type=>'SELECT LIST'
,p_is_required=>true
,p_default_value=>'SQL_QUERY'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'RENDER'
,p_lov_type=>'STATIC'
);
wwv_flow_api.create_plugin_attr_value(
p_id=>wwv_flow_api.id(32500187205091300296)
,p_plugin_attribute_id=>wwv_flow_api.id(32500186868469300295)
,p_display_sequence=>10
,p_display_value=>'Collection'
,p_return_value=>'COLLECTION'
);
wwv_flow_api.create_plugin_attr_value(
p_id=>wwv_flow_api.id(32500187749640300296)
,p_plugin_attribute_id=>wwv_flow_api.id(32500186868469300295)
,p_display_sequence=>20
,p_display_value=>'SQL Query'
,p_return_value=>'SQL_QUERY'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500188216787300296)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>3
,p_display_sequence=>30
,p_prompt=>'Collection Name'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_display_length=>50
,p_max_length=>255
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500186868469300295)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'COLLECTION'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500188586474300296)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>4
,p_display_sequence=>40
,p_prompt=>'SQL Query'
,p_attribute_type=>'SQL'
,p_is_required=>true
,p_sql_min_column_count=>1
,p_sql_max_column_count=>1
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500186868469300295)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'SQL_QUERY'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500189162068300297)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>5
,p_display_sequence=>50
,p_prompt=>'Collection Name'
,p_attribute_type=>'TEXT'
,p_is_required=>true
,p_display_length=>50
,p_max_length=>255
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'SUBMIT'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500189513849300297)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>6
,p_display_sequence=>60
,p_prompt=>'Submit Only When Value Changed'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'SUBMIT'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500190088455300297)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>7
,p_display_sequence=>70
,p_prompt=>'Make Synchronous (Blocking) '
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_is_translatable=>false
,p_depending_on_attribute_id=>wwv_flow_api.id(32500185262263300294)
,p_depending_on_condition_type=>'EQUALS'
,p_depending_on_expression=>'SUBMIT'
);
wwv_flow_api.create_plugin_attribute(
p_id=>wwv_flow_api.id(32500740499270539928)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_attribute_scope=>'COMPONENT'
,p_attribute_sequence=>8
,p_display_sequence=>80
,p_prompt=>'Show Spinner'
,p_attribute_type=>'CHECKBOX'
,p_is_required=>false
,p_default_value=>'Y'
,p_is_translatable=>false
);
wwv_flow_api.create_plugin_event(
p_id=>wwv_flow_api.id(32500194675296300308)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_name=>'apexclobloadrendercomplete'
,p_display_name=>'CLOB(s) Render Complete'
);
wwv_flow_api.create_plugin_event(
p_id=>wwv_flow_api.id(32500195062056300308)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_name=>'apexclobloadsubmitcomplete'
,p_display_name=>'CLOB(s) Submit Complete'
);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '3B2866756E6374696F6E2824297B0D0A0D0A2775736520737472696374273B0D0A0D0A242E776964676574282775692E61706578436C6F624C6F6164272C207B0D0A2020206F7074696F6E733A7B0D0A20202020202073686F774D6F64616C3A206E756C';
wwv_flow_api.g_varchar2_table(2) := '6C2C0D0A2020202020206469616C6F675469746C653A206E756C6C2C0D0A2020202020206C6F6164696E67496D6167655372633A206E756C6C2C0D0A202020202020616A61784964656E7469666965723A206E756C6C2C0D0A2020202020206170657854';
wwv_flow_api.g_varchar2_table(3) := '6869733A206E756C6C2C0D0A202020202020706C7567696E46696C655072656669783A206E756C6C0D0A2020207D2C0D0A2020205F6372656174653A2066756E6374696F6E2829207B0D0A20202020202076617220756977203D20746869733B0D0A0D0A';
wwv_flow_api.g_varchar2_table(4) := '2020202020207569772E5F6372656174655072697661746553746F7261676528293B0D0A2020202020207569772E5F696E6974456C656D656E747328293B0D0A2020207D2C0D0A2020205F6372656174655072697661746553746F726167653A2066756E';
wwv_flow_api.g_varchar2_table(5) := '6374696F6E2829207B0D0A20202020202076617220756977203D20746869733B0D0A0D0A2020202020207569772E5F76616C756573203D207B0D0A2020202020202020206469616C6F67436F756E74446174613A2027636C6F625F6C6F61645F6469616C';
wwv_flow_api.g_varchar2_table(6) := '6F675F636F756E74270D0A2020202020207D3B0D0A0D0A2020202020207569772E5F656C656D656E7473203D207B0D0A202020202020202020246469616C6F673A207B7D0D0A2020202020207D3B0D0A2020207D2C0D0A2020205F696E6974456C656D65';
wwv_flow_api.g_varchar2_table(7) := '6E74733A2066756E6374696F6E2829207B0D0A20202020202076617220756977203D20746869733B0D0A0D0A2020202020207569772E5F656C656D656E74732E246469616C6F67203D202428276469762E636C6F622D6C6F61642D636F6E7461696E6572';
wwv_flow_api.g_varchar2_table(8) := '27293B0D0A2020207D2C0D0A2020205F73686F775370696E6E65723A2066756E6374696F6E2829207B0D0A20202020202076617220756977203D20746869733B0D0A0D0A2020202020207569772E5F76616C7565732E7370696E6E6572203D2061706578';
wwv_flow_api.g_varchar2_table(9) := '2E7574696C2E73686F775370696E6E657228293B0D0A2020207D2C0D0A20202072656E646572436C6F623A2066756E6374696F6E286F70747329207B0D0A20202020202076617220756977203D20746869732C0D0A202020202020202020717565727953';
wwv_flow_api.g_varchar2_table(10) := '7472696E672C0D0A202020202020202020776F726B65722C0D0A202020202020202020776F726B657246696C654E616D653B0D0A0D0A202020202020696620286F7074732E73686F775370696E6E6572203D3D3D2027592729207B0D0A20202020202020';
wwv_flow_api.g_varchar2_table(11) := '20207569772E5F696E634469616C6F67436F756E7428293B0D0A0D0A202020202020202020696620287569772E5F6765744469616C6F67436F756E742829203D3D3D2031297B0D0A2020202020202020202020207569772E5F73686F775370696E6E6572';
wwv_flow_api.g_varchar2_table(12) := '28293B0D0A2020202020202020207D0D0A2020202020207D0D0A0D0A2020202020206966202877696E646F772E576F726B657229207B202F2F57656220776F726B65727320737570706F727465642C206D6F766520746F206261636B67726F756E64206A';
wwv_flow_api.g_varchar2_table(13) := '6F620D0A202020202020202020776F726B657246696C654E616D65203D2027617065782D636C6F622D6C6F61642D776F726B65722E6A73273B0D0A202020202020202020776F726B6572203D206E657720576F726B6572287569772E6F7074696F6E732E';
wwv_flow_api.g_varchar2_table(14) := '706C7567696E46696C65507265666978202B20776F726B657246696C654E616D65293B0D0A0D0A2020202020202020202F2F5573696E67206E61746976652062696E64696E6773206173206A51756572792773206361757365732070726F626C656D7320';
wwv_flow_api.g_varchar2_table(15) := '7769746820776F726B6572730D0A202020202020202020776F726B65722E6164644576656E744C697374656E657228276D657373616765272C2066756E6374696F6E286529207B0D0A2020202020202020202020207569772E5F68616E646C65436C6F62';
wwv_flow_api.g_varchar2_table(16) := '52656E6465725375636365737328652E646174612E636C6F622C206F707473293B0D0A2020202020202020207D2C2066616C7365293B0D0A0D0A202020202020202020776F726B65722E706F73744D657373616765287B0D0A2020202020202020202020';
wwv_flow_api.g_varchar2_table(17) := '20705F666C6F775F69643A202428272370466C6F77496427292E76616C28292C0D0A202020202020202020202020705F666C6F775F737465705F69643A202428272370466C6F7753746570496427292E76616C28292C0D0A202020202020202020202020';
wwv_flow_api.g_varchar2_table(18) := '705F696E7374616E63653A202428272370496E7374616E636527292E76616C28292C0D0A202020202020202020202020705F726571756573743A2027504C5547494E3D27202B206F7074732E616A61784964656E7469666965722C0D0A20202020202020';
wwv_flow_api.g_varchar2_table(19) := '20202020207830313A202752454E4445525F434C4F42272C0D0A202020202020202020202020706174683A2077696E646F772E6C6F636174696F6E2E706174686E616D652E736C69636528302C2077696E646F772E6C6F636174696F6E2E706174686E61';
wwv_flow_api.g_varchar2_table(20) := '6D652E6C617374496E6465784F6628272F2729202B2031290D0A2020202020202020207D293B0D0A2020202020207D20656C7365207B0D0A2020202020202020207175657279537472696E67203D207B0D0A202020202020202020202020705F666C6F77';
wwv_flow_api.g_varchar2_table(21) := '5F69643A202428272370466C6F77496427292E76616C28292C0D0A202020202020202020202020705F666C6F775F737465705F69643A202428272370466C6F7753746570496427292E76616C28292C0D0A202020202020202020202020705F696E737461';
wwv_flow_api.g_varchar2_table(22) := '6E63653A202428272370496E7374616E636527292E76616C28292C0D0A202020202020202020202020705F726571756573743A2027504C5547494E3D27202B206F7074732E616A61784964656E7469666965722C0D0A2020202020202020202020207830';
wwv_flow_api.g_varchar2_table(23) := '313A202752454E4445525F434C4F42270D0A2020202020202020207D3B0D0A0D0A202020202020202020242E616A6178287B0D0A202020202020202020202020747970653A2027504F5354272C0D0A20202020202020202020202075726C3A2027777776';
wwv_flow_api.g_varchar2_table(24) := '5F666C6F772E73686F77272C0D0A202020202020202020202020646174613A207175657279537472696E672C0D0A20202020202020202020202064617465547970653A202774657874272C0D0A2020202020202020202020206173796E633A2074727565';
wwv_flow_api.g_varchar2_table(25) := '2C0D0A202020202020202020202020636F6E746578743A20746869732C0D0A202020202020202020202020737563636573733A2066756E6374696F6E2864617461297B0D0A2020202020202020202020202020207569772E5F68616E646C65436C6F6252';
wwv_flow_api.g_varchar2_table(26) := '656E6465725375636365737328646174612C206F707473293B0D0A2020202020202020202020207D0D0A2020202020202020207D293B0D0A2020202020207D0D0A2020207D2C0D0A2020205F68616E646C65436C6F6252656E646572537563636573733A';
wwv_flow_api.g_varchar2_table(27) := '2066756E6374696F6E28646174612C206F70747329207B0D0A20202020202076617220756977203D20746869733B0D0A0D0A2020202020202F2F202473286F7074732E24656C6D745B305D2C2064617461293B0D0A202020202020617065782E6974656D';
wwv_flow_api.g_varchar2_table(28) := '286F7074732E24656C6D745B305D292E73657456616C75652864617461293B0D0A202020202020242E64617461286F7074732E24656C6D745B305D2C202764656661756C7456616C7565272C2064617461293B0D0A0D0A202020202020696620286F7074';
wwv_flow_api.g_varchar2_table(29) := '732E73686F775370696E6E6572203D3D3D2027592729207B0D0A2020202020202020207569772E5F6465634469616C6F67436F756E7428293B0D0A2020202020207D0D0A0D0A202020202020696620287569772E5F6765744469616C6F67436F756E7428';
wwv_flow_api.g_varchar2_table(30) := '29203D3D3D203029207B0D0A2020202020202020207569772E5F76616C7565732E7370696E6E65722E72656D6F766528293B0D0A0D0A2020202020202020202428646F63756D656E74292E74726967676572282761706578636C6F626C6F616472656E64';
wwv_flow_api.g_varchar2_table(31) := '6572636F6D706C65746527293B0D0A2020202020207D0D0A2020207D2C0D0A2020207375626D6974436C6F623A2066756E6374696F6E286F707473297B0D0A20202020202076617220756977203D20746869732C0D0A202020202020202020656C6D742C';
wwv_flow_api.g_varchar2_table(32) := '0D0A202020202020202020636C6F62446174612C0D0A20202020202020202064656661756C7456616C75652C0D0A2020202020202020207175657279537472696E672C0D0A202020202020202020776F726B65723B0D0A0D0A202020202020656C6D7420';
wwv_flow_api.g_varchar2_table(33) := '3D206F7074732E24656C6D745B305D3B0D0A2020202020202F2F2043415345202D207768656E207573696E672072696368207465787420656469746F72207673207374616E64617264207465787420617265612E0D0A202020202020696620282428656C';
wwv_flow_api.g_varchar2_table(34) := '6D74292E686173436C6173732822726963685F746578745F656469746F72222929207B0D0A20202020202020202F2F2044756520746F207261636520636F6E646974696F6E2C2031732064656C6179206973206164646564206265666F72652074686520';
wwv_flow_api.g_varchar2_table(35) := '67657456616C756528290D0A20202020202020202F2F2054686973206973206E6F7420616E20696465616C20736F6C7574696F6E2E202053756767657374696F6E732077656C636F6D652E0D0A202020202020202073657454696D656F75742866756E63';
wwv_flow_api.g_varchar2_table(36) := '74696F6E28297B766F69642830293B7D2C2031303030293B0D0A2020202020207D0D0A0D0A2020202020202F2F204C657665726167652041504558204A53206C6962726172790D0A202020202020636C6F6244617461203D20617065782E6974656D2865';
wwv_flow_api.g_varchar2_table(37) := '6C6D74292E67657456616C756528293B0D0A0D0A20202020202064656661756C7456616C7565203D20242E6461746128656C6D742C202764656661756C7456616C756527293B0D0A202020202020247328656C6D742C202727293B202F2F616464656420';
wwv_flow_api.g_varchar2_table(38) := '64756520746F2074726F75626C65207375626D697474696E6720706167652C206C6F6F6B20696E746F206361746368696E67206572726F727320616E642070757474696E672076616C756573206261636B0D0A0D0A202020202020696620286F7074732E';
wwv_flow_api.g_varchar2_table(39) := '6368616E67654F6E6C79203D3D3D20274E27207C7C20636C6F624461746120213D3D2064656661756C7456616C756529207B0D0A202020202020202020696620286F7074732E73686F775370696E6E6572203D3D3D2027592729207B0D0A202020202020';
wwv_flow_api.g_varchar2_table(40) := '2020202020207569772E5F696E634469616C6F67436F756E7428293B0D0A0D0A202020202020202020202020696620287569772E5F6765744469616C6F67436F756E742829203D3D3D2031297B0D0A2020202020202020202020202020207569772E5F73';
wwv_flow_api.g_varchar2_table(41) := '686F775370696E6E657228293B0D0A2020202020202020202020207D0D0A2020202020202020207D0D0A0D0A202020202020202020696620286F7074732E6D616B65426C6F636B696E67203D3D3D2027592729207B0D0A20202020202020202020202071';
wwv_flow_api.g_varchar2_table(42) := '75657279537472696E67203D207B0D0A202020202020202020202020202020705F666C6F775F69643A202428272370466C6F77496427292E76616C28292C0D0A202020202020202020202020202020705F666C6F775F737465705F69643A202428272370';
wwv_flow_api.g_varchar2_table(43) := '466C6F7753746570496427292E76616C28292C0D0A202020202020202020202020202020705F696E7374616E63653A202428272370496E7374616E636527292E76616C28292C0D0A202020202020202020202020202020705F726571756573743A202750';
wwv_flow_api.g_varchar2_table(44) := '4C5547494E3D27202B206F7074732E616A61784964656E7469666965722C0D0A2020202020202020202020202020207830313A20275355424D49545F434C4F42272C0D0A2020202020202020202020202020206630313A205B5D0D0A2020202020202020';
wwv_flow_api.g_varchar2_table(45) := '202020207D3B0D0A0D0A2020202020202020202020207175657279537472696E67203D207569772E5F6368756E6B436C6F6228636C6F62446174612C2033303030302C20207175657279537472696E67293B0D0A0D0A202020202020202020202020242E';
wwv_flow_api.g_varchar2_table(46) := '616A6178287B0D0A202020202020202020202020202020747970653A2027504F5354272C0D0A20202020202020202020202020202075726C3A20277777765F666C6F772E73686F77272C0D0A202020202020202020202020202020646174613A20717565';
wwv_flow_api.g_varchar2_table(47) := '7279537472696E672C0D0A20202020202020202020202020202064617465547970653A202774657874272C0D0A2020202020202020202020202020206173796E633A2066616C73652C0D0A202020202020202020202020202020636F6E746578743A2074';
wwv_flow_api.g_varchar2_table(48) := '6869732C0D0A202020202020202020202020202020737563636573733A2066756E6374696F6E2864617461297B0D0A2020202020202020202020202020202020207569772E5F68616E646C655375626D6974436C6F6253756363657373286F707473293B';
wwv_flow_api.g_varchar2_table(49) := '0D0A2020202020202020202020202020207D0D0A2020202020202020202020207D293B0D0A2020202020202020207D20656C7365207B0D0A2020202020202020202020206966202877696E646F772E576F726B657229207B202F2F57656220776F726B65';
wwv_flow_api.g_varchar2_table(50) := '727320737570706F727465642C206D6F766520746F206261636B67726F756E64206A6F620D0A202020202020202020202020202020776F726B6572203D206E657720576F726B6572287569772E6F7074696F6E732E706C7567696E46696C655072656669';
wwv_flow_api.g_varchar2_table(51) := '78202B2027617065782D636C6F622D6C6F61642D776F726B65722E6A7327293B0D0A0D0A2020202020202020202020202020202F2F5573696E67206E61746976652062696E64696E6773206173206A51756572792773206361757365732070726F626C65';
wwv_flow_api.g_varchar2_table(52) := '6D73207769746820776F726B6572730D0A202020202020202020202020202020776F726B65722E6164644576656E744C697374656E657228276D657373616765272C2066756E6374696F6E286529207B0D0A202020202020202020202020202020202020';
wwv_flow_api.g_varchar2_table(53) := '7569772E5F68616E646C655375626D6974436C6F6253756363657373286F707473293B0D0A2020202020202020202020202020207D2C2066616C7365293B0D0A0D0A202020202020202020202020202020776F726B65722E706F73744D65737361676528';
wwv_flow_api.g_varchar2_table(54) := '7B0D0A202020202020202020202020202020202020705F666C6F775F69643A202428272370466C6F77496427292E76616C28292C0D0A202020202020202020202020202020202020705F666C6F775F737465705F69643A202428272370466C6F77537465';
wwv_flow_api.g_varchar2_table(55) := '70496427292E76616C28292C0D0A202020202020202020202020202020202020705F696E7374616E63653A202428272370496E7374616E636527292E76616C28292C0D0A202020202020202020202020202020202020705F726571756573743A2027504C';
wwv_flow_api.g_varchar2_table(56) := '5547494E3D27202B206F7074732E616A61784964656E7469666965722C0D0A2020202020202020202020202020202020207830313A20275355424D49545F434C4F42272C0D0A202020202020202020202020202020202020636C6F62446174613A20636C';
wwv_flow_api.g_varchar2_table(57) := '6F62446174612C0D0A202020202020202020202020202020202020706174683A2077696E646F772E6C6F636174696F6E2E706174686E616D652E736C69636528302C2077696E646F772E6C6F636174696F6E2E706174686E616D652E6C617374496E6465';
wwv_flow_api.g_varchar2_table(58) := '784F6628272F2729202B2031290D0A2020202020202020202020202020207D293B0D0A2020202020202020202020207D20656C7365207B0D0A2020202020202020202020202020207175657279537472696E67203D207B0D0A2020202020202020202020';
wwv_flow_api.g_varchar2_table(59) := '20202020202020705F666C6F775F69643A202428272370466C6F77496427292E76616C28292C0D0A202020202020202020202020202020202020705F666C6F775F737465705F69643A202428272370466C6F7753746570496427292E76616C28292C0D0A';
wwv_flow_api.g_varchar2_table(60) := '202020202020202020202020202020202020705F696E7374616E63653A202428272370496E7374616E636527292E76616C28292C0D0A202020202020202020202020202020202020705F726571756573743A2027504C5547494E3D27202B206F7074732E';
wwv_flow_api.g_varchar2_table(61) := '616A61784964656E7469666965722C0D0A2020202020202020202020202020202020207830313A20275355424D49545F434C4F42272C0D0A2020202020202020202020202020202020206630313A205B5D0D0A2020202020202020202020202020207D3B';
wwv_flow_api.g_varchar2_table(62) := '0D0A0D0A2020202020202020202020202020207175657279537472696E67203D207569772E5F6368756E6B436C6F6228636C6F62446174612C2033303030302C20207175657279537472696E67293B0D0A0D0A202020202020202020202020202020242E';
wwv_flow_api.g_varchar2_table(63) := '616A6178287B0D0A202020202020202020202020202020202020747970653A2027504F5354272C0D0A20202020202020202020202020202020202075726C3A20277777765F666C6F772E73686F77272C0D0A202020202020202020202020202020202020';
wwv_flow_api.g_varchar2_table(64) := '646174613A207175657279537472696E672C0D0A20202020202020202020202020202020202064617465547970653A202774657874272C0D0A2020202020202020202020202020202020206173796E633A20747275652C0D0A2020202020202020202020';
wwv_flow_api.g_varchar2_table(65) := '20202020202020636F6E746578743A20746869732C0D0A202020202020202020202020202020202020737563636573733A2066756E6374696F6E2864617461297B0D0A2020202020202020202020202020202020202020207569772E5F68616E646C6553';
wwv_flow_api.g_varchar2_table(66) := '75626D6974436C6F6253756363657373286F707473293B0D0A2020202020202020202020202020202020207D0D0A2020202020202020202020202020207D293B0D0A2020202020202020202020207D0D0A2020202020202020207D0D0A2020202020207D';
wwv_flow_api.g_varchar2_table(67) := '0D0A2020207D2C0D0A2020205F68616E646C655375626D6974436C6F62537563636573733A2066756E6374696F6E286F707473297B0D0A20202020202076617220756977203D20746869733B0D0A0D0A202020202020696620286F7074732E73686F7753';
wwv_flow_api.g_varchar2_table(68) := '70696E6E6572203D3D3D2027592729207B0D0A2020202020202020207569772E5F6465634469616C6F67436F756E7428293B0D0A2020202020207D0D0A0D0A202020202020696620287569772E5F6765744469616C6F67436F756E742829203D3D3D2030';
wwv_flow_api.g_varchar2_table(69) := '29207B0D0A2020202020202020207569772E5F76616C7565732E7370696E6E65722E72656D6F766528293B0D0A0D0A2020202020202020202428646F63756D656E74292E74726967676572282761706578636C6F626C6F61647375626D6974636F6D706C';
wwv_flow_api.g_varchar2_table(70) := '65746527293B0D0A2020202020207D0D0A2020207D2C0D0A2020205F696E634469616C6F67436F756E743A2066756E6374696F6E28297B0D0A20202020202076617220756977203D20746869732C0D0A202020202020202020636F756E74203D20756977';
wwv_flow_api.g_varchar2_table(71) := '2E5F6765744469616C6F67436F756E7428293B0D0A0D0A20202020202069662028636F756E74203D3D3D20756E646566696E6564207C7C20636F756E74203C203029207B0D0A202020202020202020636F756E74203D20313B0D0A202020202020202020';
wwv_flow_api.g_varchar2_table(72) := '7569772E5F7365744469616C6F67436F756E7428636F756E74293B0D0A2020202020207D20656C7365207B0D0A202020202020202020636F756E742B2B3B0D0A2020202020202020207569772E5F7365744469616C6F67436F756E7428636F756E74293B';
wwv_flow_api.g_varchar2_table(73) := '0D0A2020202020207D0D0A2020207D2C0D0A2020205F6465634469616C6F67436F756E743A2066756E6374696F6E28297B0D0A20202020202076617220756977203D20746869732C0D0A202020202020202020636F756E74203D207569772E5F67657444';
wwv_flow_api.g_varchar2_table(74) := '69616C6F67436F756E7428293B0D0A0D0A20202020202069662028636F756E74203E3D203029207B0D0A202020202020202020636F756E742D2D3B0D0A2020202020202020207569772E5F7365744469616C6F67436F756E7428636F756E74293B0D0A20';
wwv_flow_api.g_varchar2_table(75) := '20202020207D0D0A2020207D2C0D0A2020205F6765744469616C6F67436F756E743A2066756E6374696F6E28297B0D0A20202020202076617220756977203D20746869732C0D0A202020202020202020636F756E74203D20242E6461746128646F63756D';
wwv_flow_api.g_varchar2_table(76) := '656E742C207569772E5F76616C7565732E6469616C6F67436F756E7444617461293B0D0A0D0A20202020202072657475726E2028636F756E74203D3D3D20756E646566696E6564207C7C20636F756E74203C203029203F2030203A20636F756E743B0D0A';
wwv_flow_api.g_varchar2_table(77) := '2020207D2C0D0A2020205F7365744469616C6F67436F756E743A2066756E6374696F6E286E6577436F756E74297B0D0A20202020202076617220756977203D20746869733B0D0A0D0A202020202020242E6461746128646F63756D656E742C207569772E';
wwv_flow_api.g_varchar2_table(78) := '5F76616C7565732E6469616C6F67436F756E74446174612C206E6577436F756E74293B0D0A2020207D2C0D0A2020205F6368756E6B436C6F623A2066756E6374696F6E28636C6F622C73697A652C7175657279537472696E67297B0D0A20202020202076';
wwv_flow_api.g_varchar2_table(79) := '617220756977203D20746869732C0D0A2020202020202020206C6F6F70436F756E74203D204D6174682E666C6F6F7228636C6F622E6C656E677468202F2073697A6529202B20313B0D0A0D0A202020202020666F7220287661722069203D20303B206920';
wwv_flow_api.g_varchar2_table(80) := '3C206C6F6F70436F756E743B20692B2B29207B0D0A2020202020202020207175657279537472696E672E6630312E7075736828636C6F622E736C6963652873697A65202A20692C73697A652A28692B312929293B0D0A2020202020207D0D0A0D0A202020';
wwv_flow_api.g_varchar2_table(81) := '20202072657475726E207175657279537472696E673B0D0A2020207D0D0A7D293B0D0A7D2928617065782E6A5175657279293B';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
p_id=>wwv_flow_api.id(12314697115760096)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_file_name=>'apex-clob-load.js'
,p_mime_type=>'application/javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table)
);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '766172207175657279537472696E67203D2027273B0A0A66756E6374696F6E20616464506172616D286E616D652C2076616C29207B0A202020696620287175657279537472696E67203D3D3D20272729207B0A2020202020207175657279537472696E67';
wwv_flow_api.g_varchar2_table(2) := '203D206E616D65202B20273D27202B20282876616C20213D206E756C6C29203F20656E636F6465555249436F6D706F6E656E742876616C2920203A202727293B0A2020207D20656C7365207B0A2020202020207175657279537472696E67203D20717565';
wwv_flow_api.g_varchar2_table(3) := '7279537472696E67202B202726272B206E616D65202B20273D27202B20282876616C20213D206E756C6C29203F20656E636F6465555249436F6D706F6E656E742876616C2920203A20272720293B0A2020207D0A7D0A0A66756E6374696F6E206368756E';
wwv_flow_api.g_varchar2_table(4) := '6B436C6F6228636C6F622C2073697A6529207B0A202020766172206C6F6F70436F756E74203D204D6174682E666C6F6F7228636C6F622E6C656E677468202F2073697A6529202B20313B0A0A202020666F7220287661722069203D20303B2069203C206C';
wwv_flow_api.g_varchar2_table(5) := '6F6F70436F756E743B20692B2B29207B0A202020202020616464506172616D2827663031272C20636C6F622E736C6963652873697A65202A20692C73697A652A28692B312929293B0A2020207D0A7D0A0A2F2A2A0A20202054686520666F6C6C6F77696E';
wwv_flow_api.g_varchar2_table(6) := '6720616A6178206C696272617279207761732074616B656E2066726F6D206D696E69616A61780A20202068747470733A2F2F636F64652E676F6F676C652E636F6D2F702F6D696E69616A61782F0A202A2F0A0A66756E6374696F6E20242865297B696628';
wwv_flow_api.g_varchar2_table(7) := '747970656F6620653D3D27737472696E672729653D646F63756D656E742E676574456C656D656E74427949642865293B72657475726E20657D3B0A66756E6374696F6E20636F6C6C65637428612C66297B766172206E3D5B5D3B666F722876617220693D';
wwv_flow_api.g_varchar2_table(8) := '303B693C612E6C656E6774683B692B2B297B76617220763D6628615B695D293B69662876213D6E756C6C296E2E707573682876297D72657475726E206E7D3B0A0A616A61783D7B7D3B0A616A61782E783D66756E6374696F6E28297B7472797B72657475';
wwv_flow_api.g_varchar2_table(9) := '726E206E657720416374697665584F626A65637428274D73786D6C322E584D4C4854545027297D63617463682865297B7472797B72657475726E206E657720416374697665584F626A65637428274D6963726F736F66742E584D4C4854545027297D6361';
wwv_flow_api.g_varchar2_table(10) := '7463682865297B72657475726E206E657720584D4C487474705265717565737428297D7D7D3B0A616A61782E73657269616C697A653D66756E6374696F6E2866297B76617220673D66756E6374696F6E286E297B72657475726E20662E676574456C656D';
wwv_flow_api.g_varchar2_table(11) := '656E747342795461674E616D65286E297D3B766172206E763D66756E6374696F6E2865297B696628652E6E616D652972657475726E20656E636F6465555249436F6D706F6E656E7428652E6E616D65292B273D272B656E636F6465555249436F6D706F6E';
wwv_flow_api.g_varchar2_table(12) := '656E7428652E76616C7565293B656C73652072657475726E2027277D3B76617220693D636F6C6C65637428672827696E70757427292C66756E6374696F6E2869297B69662828692E74797065213D27726164696F272626692E74797065213D2763686563';
wwv_flow_api.g_varchar2_table(13) := '6B626F7827297C7C692E636865636B65642972657475726E206E762869297D293B76617220733D636F6C6C6563742867282773656C65637427292C6E76293B76617220743D636F6C6C65637428672827746578746172656127292C6E76293B7265747572';
wwv_flow_api.g_varchar2_table(14) := '6E20692E636F6E6361742873292E636F6E6361742874292E6A6F696E28272627293B7D3B0A616A61782E73656E643D66756E6374696F6E28752C662C6D2C61297B76617220783D616A61782E7828293B782E6F70656E286D2C752C74727565293B782E6F';
wwv_flow_api.g_varchar2_table(15) := '6E726561647973746174656368616E67653D66756E6374696F6E28297B696628782E726561647953746174653D3D34296628782E726573706F6E736554657874297D3B6966286D3D3D27504F53542729782E736574526571756573744865616465722827';
wwv_flow_api.g_varchar2_table(16) := '436F6E74656E742D74797065272C276170706C69636174696F6E2F782D7777772D666F726D2D75726C656E636F64656427293B782E73656E642861297D3B0A616A61782E6765743D66756E6374696F6E2875726C2C66756E63297B616A61782E73656E64';
wwv_flow_api.g_varchar2_table(17) := '2875726C2C66756E632C2747455427297D3B0A616A61782E676574733D66756E6374696F6E2875726C297B76617220783D616A61782E7828293B782E6F70656E2827474554272C75726C2C66616C7365293B782E73656E64286E756C6C293B7265747572';
wwv_flow_api.g_varchar2_table(18) := '6E20782E726573706F6E7365546578747D3B0A616A61782E706F73743D66756E6374696F6E2875726C2C66756E632C61726773297B616A61782E73656E642875726C2C66756E632C27504F5354272C61726773297D3B0A616A61782E7570646174653D66';
wwv_flow_api.g_varchar2_table(19) := '756E6374696F6E2875726C2C656C6D297B76617220653D2428656C6D293B76617220663D66756E6374696F6E2872297B652E696E6E657248544D4C3D727D3B616A61782E6765742875726C2C66297D3B0A616A61782E7375626D69743D66756E6374696F';
wwv_flow_api.g_varchar2_table(20) := '6E2875726C2C656C6D2C66726D297B76617220653D2428656C6D293B76617220663D66756E6374696F6E2872297B652E696E6E657248544D4C3D727D3B616A61782E706F73742875726C2C662C616A61782E73657269616C697A652866726D29297D3B0A';
wwv_flow_api.g_varchar2_table(21) := '0A6164644576656E744C697374656E657228276D657373616765272C2066756E6374696F6E286529207B0A20202076617220776F726B6572203D20746869732C0A20202020202064617461203D20652E646174613B0A0A20202069662028646174612E78';
wwv_flow_api.g_varchar2_table(22) := '3031203D3D3D20275355424D49545F434C4F422729207B0A202020202020616464506172616D2827705F666C6F775F6964272C20646174612E705F666C6F775F6964293B0A202020202020616464506172616D2827705F666C6F775F737465705F696427';
wwv_flow_api.g_varchar2_table(23) := '2C20646174612E705F666C6F775F737465705F6964293B0A202020202020616464506172616D2827705F696E7374616E6365272C20646174612E705F696E7374616E6365293B0A202020202020616464506172616D2827705F72657175657374272C2064';
wwv_flow_api.g_varchar2_table(24) := '6174612E705F72657175657374293B0A202020202020616464506172616D2827783031272C20646174612E783031293B0A0A2020202020206368756E6B436C6F6228646174612E636C6F62446174612C203330303030293B0A0A202020202020616A6178';
wwv_flow_api.g_varchar2_table(25) := '2E706F7374280A202020202020202020646174612E70617468202B20277777765F666C6F772E73686F77272C0A20202020202020202066756E6374696F6E2864617461297B0A202020202020202020202020776F726B65722E706F73744D657373616765';
wwv_flow_api.g_varchar2_table(26) := '28277375636365737327293B0A2020202020202020207D2C0A2020202020202020207175657279537472696E670A202020202020293B0A2020207D20656C7365207B202F2F6D7573742062652052454E4445525F434C4F420A2020202020206164645061';
wwv_flow_api.g_varchar2_table(27) := '72616D2827705F666C6F775F6964272C20646174612E705F666C6F775F6964293B0A202020202020616464506172616D2827705F666C6F775F737465705F6964272C20646174612E705F666C6F775F737465705F6964293B0A2020202020206164645061';
wwv_flow_api.g_varchar2_table(28) := '72616D2827705F696E7374616E6365272C20646174612E705F696E7374616E6365293B0A202020202020616464506172616D2827705F72657175657374272C20646174612E705F72657175657374293B0A202020202020616464506172616D2827783031';
wwv_flow_api.g_varchar2_table(29) := '272C20646174612E783031293B0A0A202020202020616A61782E706F7374280A202020202020202020646174612E70617468202B20277777765F666C6F772E73686F77272C0A20202020202020202066756E6374696F6E2864617461297B0A2020202020';
wwv_flow_api.g_varchar2_table(30) := '202020202020207661722072657476616C203D207B7D3B0A0A20202020202020202020202072657476616C2E636C6F62203D20646174613B0A0A202020202020202020202020776F726B65722E706F73744D6573736167652872657476616C293B0A2020';
wwv_flow_api.g_varchar2_table(31) := '202020202020207D2C0A2020202020202020207175657279537472696E670A202020202020293B0A2020207D0A0A7D2C2066616C7365293B0A0A';
null;
end;
/
begin
wwv_flow_api.create_plugin_file(
p_id=>wwv_flow_api.id(32500759415696546858)
,p_plugin_id=>wwv_flow_api.id(32500181608295300285)
,p_file_name=>'apex-clob-load-worker.js'
,p_mime_type=>'text/javascript'
,p_file_charset=>'utf-8'
,p_file_content=>wwv_flow_api.varchar2_to_blob(wwv_flow_api.g_varchar2_table)
);
end;
/
begin
wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false), p_is_component_import => true);
commit;
end;
/
set verify on feedback on define on
prompt ...done