Re: Help in Database Triggers...

From: Bobby S Mukundan <bobby_at_sdt.com>
Date: 1995/09/08
Message-ID: <42q5on$jbh_at_aadt.sdt.com>#1/1

You CANNOT declare/create a procedure inside a Database Trigger (atleast not till V7.2)!!

One solution is to have a couple of variables - ch1 and ch2 in a package and to assign these values in the database trigger. You can also create a procedure within the same package to do manipulate the values of these packaged variables (global within the package). You can pass parameters to this procedure from your
database trigger.

rgunturu_at_bert.eecs.uic.edu (Rajasekhar Gunturu) wrote:
> Is it ok to have a procedure declared inside a database trigger?
Received on Fri Sep 08 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Tien Song Chuan: "OLE Objects Named session"
Previous message: P W Maker Deverill P: "Re: Oracle datafiles across an NFS"
Maybe reply: delphi: "Re: Help in Database Triggers..."
Maybe reply: Thomas B. Cox: "Re: Help in Database Triggers..."
Maybe reply: Alexandr I. Alesinsky: "Re: Help in Database Triggers..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message