set define '^'
set verify off
prompt ...wwv_flow_help
create or replace package body wwv_flow_help wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
121
2 :e:
1PACKAGE:
1BODY:
1WWV_FLOW_HELP:
1G_RUNTIME_DOC_PATH:
1VARCHAR2:
14000:
1FUNCTION:
1GET_DOC_PATH:
1RETURN:
1L_PATH:
1OWA_UTIL:
1GET_CGI_ENV:
1HTTP_HOST:
1INSTR:
1:::
1=:
10:
1||:
1SERVER_PORT:
1WWV_FLOW_GLOBAL:
1G_IMAGE_PREFIX:
1doc/:
1GET_REQUEST_PROTOCOL:
1L_PROTOCOL:
132:
1LOWER:
1REQUEST_PROTOCOL:
1https:
1http:
1GET_RUNTIME_DOC_PATH:
1IS NULL:
1:://:
1V:
1BROWSER_LANGUAGE:
1ja:
1ja/:
1GET_DOC:
1P_URL:
1P_LANG:
1CLOB:
1L_HTTP_REQ:
1UTL_HTTP:
1REQ:
1L_HTTP_RESP:
1RESP:
1L_BUFFER:
132767:
1L_VALUE:
1SET_PERSISTENT_CONN_SUPPORT:
1TRUE:
1SET_BODY_CHARSET:
1utf-8:
1WWV_FLOW:
1DEBUG:
1Fetching file from:: :
1BEGIN_REQUEST:
1GET:
1GET_RESPONSE:
1DBMS_LOB:
1CREATETEMPORARY:
1FALSE:
1OPEN:
1LOB_READWRITE:
1LOOP:
1READ_TEXT:
1WRITEAPPEND:
1LENGTH:
1OTHERS:
1SQLCODE:
1!=:
1-:
129266:
1RAISE:
1END_RESPONSE:
1CREATE_HELP_INDEX:
1L_CLOB:
1L_XML:
1XMLTYPE:
1L_MAP:
1L_INDEX:
1NUMBER:
1L_FILENAME:
1L_TITLE:
1L_LANG:
110:
1L_DOC_PATH:
1L_INDEX_NAME:
1100:
1L_PT_INDEX_NAME:
1L_TABLE_NAME:
1L_URL:
1L_PLAINTEXT:
1UPPER:
1JA:
1WWV_FLOW_OH_JA_IDX:
1WWV_FLOW_OH_JA_PT_IDX:
1WWV_FLOW_ONLINE_HELP_JA:
1WWV_FLOW_OH_IDX:
1WWV_FLOW_OH_PT_IDX:
1WWV_FLOW_ONLINE_HELP:
1C1:
1INDEX_NAME:
1USER_INDEXES:
1select index_name:n from user_indexes:n where +
1index_name = l_index_name or index_name = l_pt_index_name:
1Dropping existing index:: :
1EXECUTE:
1IMMEDIATE:
1drop index :
1 force:
1DELETE from wwv_flow_online_help:
1ELSIF:
1DELETE from wwv_flow_online_help_ja:
1CTX_USER_PREFERENCES:
1PRE_NAME:
1select null:n from ctx_user_preferences:n +
1 where pre_name = 'HTMLDB_JAPANESE_LEXER':
1CTX_DDL:
1DROP_PREFERENCE:
1HTMLDB_JAPANESE_LEXER:
1EXIT:
1COMMIT:
1doc_map.xml:
1Documentation mapping file :
1GETLENGTH:
1 bytes.:
1CREATEXML:
1EXTRACT:
1//map:
1FREETEMPORARY:
11:
1EXISTSNODE:
1//map[:
1]:
1]/@filename:
1GETSTRINGVAL:
1]/@title:
1IS NOT NULL:
1http:://:
1Inserting URL:: :
1URL:
1FILENAME:
1TITLE:
1INSERT into wwv_flow_online_help( url, filename, title) :n val+
1ues( l_url, l_filename, l_title):
1CSET:
1INSERT into wwv_flow_online_help_ja( url, filename, title, cset) :n +
1 values( l_url, l_filename, l_title, 'JA16SJIS'):
1+:
1Creating index :
1create index :
1 on :
1(url) :
1 indextype is ctxsys.context parameters('filter ctxsys.null_filter datastore +
1ctxsys.url_datastore'):
1CREATE_PREFERENCE:
1JAPANESE_LEXER:
1 indextype is ctxsys.context parameters('filter ctxsys.inso_filter datastore +
1ctxsys.url_datastore lexer htmldb_japanese_lexer charset column cset'):
1ID:
1select id:n from wwv_flow_online_help:
1CTX_DOC:
1FILTER:
1SUBSTR:
19:
1:
1PLAINTEXT:
1UPDATE wwv_flow_online_help:n set plaintext = l_plaintext:n +
1 where id = c1.id:
1select id:n from wwv_flow_online_help_ja:
1UPDATE wwv_flow_online_help_ja:n set plaintext = l_plaintext:n +
1 where id = c1.id:
1(plaintext) :
1 indextype is ctxsys.context parameters('nopopulate'):
1 indextype is ctxsys.context parameters('nopopulate lexer htmldb_japanese_lex+
1er'):
1SHOW_HELP:
1P_SESSION:
1P_FLOW_ID:
1P_STEP_ID:
1L_HELP_FILE:
1L_STEP_ID:
1toc.htm:
15000:
1,:
1TO_NUMBER:
19999D9999:
1NLS_NUMERIC_CHARACTERS=',.':
1NLS_NUMERIC_CHARACTERS='.,':
1TRIM:
1HELP_TEXT:
1HELP_FILE:
1WWV_FLOW_STEPS:
1FLOW_ID:
1select trim(dbms_lob.substr(help_text,4000,1)) help_file:n +
1 from wwv_flow_steps:n where flow_id = p_flow_id:n +
1 and id = l_step_id:
1HTP:
1P:
1:n HTML DB<+
1/head>:n :n :
1SHOW_NAVIGATION:
1L_SHOWFIND:
1BOOLEAN:
1L_INDEXES_EXIST:
12:
1NLS_DATABASE_PARAMETERS:
1PARAMETER:
1VALUE:
1select null:n from nls_database_parameters:n +
1 where upper(parameter) = 'NLS_CHARACTERSET':n and+
1 value in ('AL32UTF8','UTF8','JA16EUC','JA16SJIS'):
1COUNT:
1INDEX_CNT:
1select count(*) index_cnt:n from user_indexes:n +
1 where index_name in ('WWV_FLOW_OH_JA_IDX','WWV_FLOW_OH_JA_PT_IDX'):
1select count(*) index_cnt:n from user_indexes:n +
1 where index_name in ('WWV_FLOW_OH_IDX','WWV_FLOW_OH_PT_IDX'):
1:n Navigation:n :n :n :
1:
1:
1
:
1:n