rem ----------------------------------------------------------------------------
rem File:        $RCSfile: WSGOCOL.SQL $
rem Author:      $Author: ipenning $
rem Date:        $Date: 2000/04/06 09:06:53 $
rem Version:     $Revision: 1.3 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem Copyright:   (c) Oracle Corporation 1994.  All Rights Reserved.
rem ----------------------------------------------------------------------------
rem Log of Changes from RCS
rem ----------------------------------------------------------------------------
rem $Log: WSGOCOL.SQL $
rem Revision 1.3  2000/04/06  09:06:53  ipenning
rem Call package installation in same file as this one
rem
rem Revision 1.2  1998/03/12  14:55:58  abaldwin
rem Added compilation report to OCO installation to make it more user friendly
rem
rem Revision 1.1  1997/03/14  12:47:18  lmeredit
rem Initial revision
rem
rem Revision 1.2  1997/03/12  11:54:28  pcarlisl
rem create results table when installing oco package
rem
rem Revision 1.1  1996/10/21  14:08:27  pcarlisl
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  
prompt Spooling to wsgocol.log

column LABEL new_value LABEL_VALUE noprint 
column TEXT format A50 word_wrap 
column TYPE format A2
column POSITION heading 'COL' format 999
column LINE format 99999
define LABEL_VALUE = 'There were no errors'
set    feedback off
set    linesize 96

spool wsgocol.log
@@wsgocol.pks
@@wsgocol.pkb

ttitle skip 2 center 'Webserver Generator Oracle Context Option Library Compilation Report' skip 1 -
              center '--------------------------------------------------------------------' skip 1

set heading off
select null from dual
/
ttitle off
set heading on
break on name on type

select
  '' LABEL,
  name,
  decode (type,'PACKAGE BODY','PB','PACKAGE SPEC','PS',type) TYPE,
  line, 
  position,
  text
from
  user_errors
where
  name = 'WSGOCOL'
order by
  NAME,
  TYPE,
  SEQUENCE
/

set scan on
prompt &&LABEL_VALUE
prompt

prompt Drop and recreate results table
drop table CG$RESTAB;
create table CG$RESTAB (TEXTKEY VARCHAR2(64), SCORE NUMBER, CONID NUMBER);
spool off
--exit
rem  
rem ----------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: WSGOCOL.SQL $
rem ----------------------------------------------------------------------------
