rem ----------------------------------------------------------------------------
rem File:        $RCSfile: cktrig.sql $
rem Author:      $Author: aobhrai $
rem Date:        $Date: 1998/01/22 11:12:35 $
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: cktrig.sql $
rem Revision 1.2  1998/01/22  11:12:35  aobhrai
rem *** empty log message ***
rem
rem Revision 1.1  1998/01/22  09:14:51  aobhrai
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  
REM
REM  This ORACLE7 command file was generated by Oracle Server Generator
REM  Version 5.5.10.0.0 on 22-JAN-98
REM
REM For application DLD703 version 1 database DLD
REM
REM TRIGGER
REM      CK_APP_LOG_TR1

REM
REM     Cascade delete CDI text when deleting application logic
REM
PROMPT 
PROMPT Creating Trigger CK_APP_LOG_TR1
CREATE OR REPLACE TRIGGER ck_app_log_tr1
BEFORE DELETE 
ON CK_APPLICATION_LOGIC
FOR EACH ROW
DECLARE
BEGIN
  delete cdi_text where txt_ref = :old.al_id;
END;
/

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