Re: Reconstruct trigger from source - How?

From: Srini Sunderarajan <ou79019_at_deere.com>
Date: 1996/01/18
Message-ID: <DLE3F3.A60_at_deere.com>#1/1

• ***********************************************************
• * Name : recretrigger.sql
• * Purpose : Recreates User Triggers
• * Output : cretrigger.sql Run This to recreate triggers.
• ************************************************************ set feedback off set verify off set termout off set echo off set long 15000 set pages 0 spool cretrigger.sql select 'Create Or Replace Trigger '||Description, Trigger_Body,'/' From User_Triggers / spool off set verify on set feedback on set termout on

  ---

Similar way functions and procedures can also be created using following script

---

• ***********************************************************
• * Name : recrefunpro.sql
• * Purpose : Recreates functions,procedures,packages.
• * Output : crefunpro.sql
• ************************************************************ set verify off set feedback off set echo off set linesize 79 set pause off set pages 0 column line1 format A79 column line2 format A79 column line3 format A79 column line4 format A79 column line5 format A79 column line6 format A79 column line7 format A79 Define Output = procfunc.sql break on line1 skip 0 nodup Spool &Output Select Distinct 'Prompt Create Or Replace '||T1.type||' '||user||'.'||T1.name line1, 'Select Substr(text,1,80)' line2, ' From User_source ' line3, ' Where Name = '''||T1.name||'''' line4, ' And type = '''||T1.type||'''' line5, ' Order by line;' line6, 'Prompt /' line7 from User_Source T1 / spool off clear columns clear breaks spool crefunpro.sql _at_procfunc spool off
• Use crefunpro.sql to re-create functions/procedures/packages

Srini(ou79019_at_deere.com)
~ Received on Thu Jan 18 1996 - 00:00:00 CET