Re: HELP: SQL*PLUS 3.3

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/24
Message-ID: <19970224094800.EAA08510@ladder02.news.aol.com>#1/1

We have several database triggers which pass the :old values as parameters to stored procedures where I work. One thought is whether the parameter you are passing is defined as IN OUT in the stored procedure, which ORACLE would not allow 'cos you could potentially change the :old value.

Rob

---

---

Subject: HELP: SQL*PLUS 3.3
From: "Darren Young" <dly_at_nbnet.nb.ca>
Date: 21 Feb 1997 20:10:58 GMT
Message-ID: <01bc2033$9d098900$8b85b3cf_at_dly.nbnet.nb.ca>

I am trying to write a BEFORE DELETE trigger for a table that has two FK's but even when the trigger complies I get an error.

Is there any body out there that knows how to pass the current values to a procedure in a trigger. I have tried to pass :old.field name but the error
message that I got said that I can't use :old in this way.

Thanks,

Darren Young
dly_at_nbnet.nb.ca Received on Mon Feb 24 1997 - 00:00:00 CST