Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\patches\3.2.1\patch

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\patches\3.2.1\patch_8338787.sql

set define '^'

Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    hfarrell   03/12/2009 - Created patch file for bug (8338787)
Rem    jkallman   04/10/2009 - Correct "set define"

declare
    ph varchar2(32767) := null;
    h  varchar2(32767) := null;
begin
    wwv_flow_security.g_security_group_id := 10;
    
    ph:=ph||'<script language="javascript">'||chr(10)||
'   function copy_custom() {'||chr(10)||
'      $s(''P77_CUSTOM_QUERY'',$v(''P77_ORIGINAL_QUERY''));'||chr(10)||
'   }'||chr(10)||
''||chr(10)||
'   function copy_enhanced() {'||chr(10)||
'      $s(''P77_CUSTOM_QUERY'',$v(''P77_ENHANCED_QUERY''));'||chr(10)||
'   }'||chr(10)||
'</script>';

update wwv_flow_steps 
    set    html_page_header = ph, 
           html_page_onload = null,
           first_item = 'AUTO_FIRST_ITEM'
    where  flow_id between 4400 and 4409 
    and    name = 'Block Details'
    and    id >= 77
    and    id < 77 + 1;

h := h||'</pre>'||chr(10)||
'   <a href="javascript:copy_enhanced();"  class="htmldbPageEditButtons">'||chr(10)||
'   <img src="#IMAGE_PREFIX#htmldb/icons/copy_small.gif"/></a>';

update wwv_flow_step_items
    set    pre_element_text = '<pre class="code_text">',
           post_element_text = h,
           read_only_when_type = 'ALWAYS'
    where  flow_id between 4400 and 4409
    and id >= 71623520929952255
    and id < 71623520929952255 + 1;

commit;

end;
/

set define '^'

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de