Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\drv0ddl.pkh

Rem
Rem Copyright (c) 1998, 2008, Oracle and/or its affiliates. All rights reserved.
Rem  NAME
Rem    drv0ddl.pkh - DR cartridge Misc DDL services
Rem  DESCRIPTION
rem
Rem  RETURNS
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    igeller    07/16/08 - bug6674374: rearchitecture optimize index rebuild
Rem    wclin      12/06/07 - XbranchMerge ymatsuda_bug-6393125 from main
Rem    wclin      12/04/07 - 
Rem    ymatsuda   09/10/07 - deferred p table creation
Rem    wclin      04/14/06 - Enable Pll Opt rebld: tbl func return only raw
Rem    wclin      01/09/06 - take out CDI hack 
Rem    wclin      12/14/05 - 
Rem    gkaminag   09/29/05 - cdi indexing ph 1 
Rem    smuralid   10/28/03 - smuralid_2table_optimize 
Rem    smuralid   06/04/03  - 
Rem    smuralid   03/06/03  - Creation

rem The following types and function are used when $P is populated
drop type dr$substring force;
create or replace type dr$substring as object
(
  part_1 varchar2(61),
  part_2 varchar2(64)
);
/
grant execute on dr$substring to public;

drop type dr$substring_set force;
create or replace type dr$substring_set as table of dr$substring;
/

create or replace package drv0ddl authid current_user is

function generate_substrings(c sys_refcursor)
   return dr$substring_set
   pipelined;

end drv0ddl;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de