Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can a Trigger call StoredProc(:new) ( Ora 7.3 )
/*Sales mode on */ This is a feature request, and this is another feature
request /* Sales mode off */
The answer to this is no and no. :new and :old are typeless records. You
can't refer to them as record.
Sorry,
--
Sybrand Bakker, Oracle DBA
<Torsten.Reichert_at_gmx.net> wrote in message
news:381F305E.D10EC83B_at_gmx.net...
> Hi,
>
> What is the type of :new and :old records of a trigger ?
> Is there any possibility
> - to pass assign the :new variable in a trigger to procedures
> - or assign its value to another variable ?
>
> I want to do something like that:
> PROCEDURE StoredProc ( alt IN OUT test_c%ROWTYPE, neu IN OUT
> test_c%ROWTYPE ) IS
> BEGIN
> NULL;
> END StoredProc;
>
> CREATE OR REPLACE TRIGGER boss
> AFTER INSERT OR UPDATE OR DELETE ON test_c
> FOR EACH ROW
> -- REFERENCING old as old_rec
> BEGIN
> StoredProc ( :old, :new );
> END;
>
> Thank you very much
>
Received on Tue Nov 02 1999 - 12:50:20 CST