rem ----------------------------------------------------------------------------
rem File:        $RCSfile: irid_seq.sql $
rem Author:      $Author: cwilliam $
rem Date:        $Date: 1998/12/14 15:17:23 $
rem Version:     $Revision: 1.2 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1998>
rem Copyright:   (c) Oracle Corporation 1998.  All Rights Reserved.
rem ----------------------------------------------------------------------------
rem Log of Changes from RCS
rem ----------------------------------------------------------------------------
rem $Log: irid_seq.sql $
rem Revision on 2000/11/02 sbhagava
rem Changed dual to sys.dual to fix bug 1311500
rem
rem Revision 1.2  1998/12/14  15:17:23  cwilliam
rem modified sequence to start at 500000 to avoid clashes with ids already
rem used by configuration
rem
rem Revision 1.1  1998/10/07  15:31:04  cwilliam
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  

rem -----------------------------------------------------------------------+
-- prompt Sequence : sdd_irid_seq
rem -----------------------------------------------------------------------+

-- create sequence sdd_irid_seq
-- start with 500000
-- /

-- Repository ids now generated from guids instead of an Oracle sequence

rem -----------------------------------------------------------------------+
prompt View : jr_sys_op_guid 
rem -----------------------------------------------------------------------+
-- View that has a single hexadecimal GUID column 
-- 
create or replace view jr_sys_op_guid (guid) 
as
select rawtohex(sys_op_guid())
from   sys.dual
/

rem  
rem ----------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: irid_seq.sql $
rem ----------------------------------------------------------------------------

