Re: PL/SQL Trigger Question

From: Eric Givler <egivler_at_flash.net>
Date: Sat, 18 Nov 2000 03:55:56 GMT
Message-ID: <g5nR5.3984$6W1.305785_at_news.flash.net>


I'm pretty sure this was asked before. Steven Feuerenstein had some sample code that aided in the creation of triggers that were to pass a record structure to stored packages for validation. I haven't seen the code, but it might come in handy for this. It might have been on TUSC's site.

<raptnor_at_my-deja.com> wrote in message news:8uuked$ilq$1_at_nnrp1.deja.com...
> I'm really new to PL/SQL so forgive me if this is a dumb question. Can
> you pass the new record to a PL/SQL procedure for processing? See below
> for code snippet.
>
> CREATE OR REPLACE TRIGGER table_valid
> BEFORE INSERT OR UPDATE ON some_table
> FOR EACH ROW
> DECLARE
> BEGIN
> TABLE_ACTIONS.VALID_RECORD(new);
> END;
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 18 2000 - 04:55:56 CET

Original text of this message