Re: :new & :old as records ?
From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1995/08/03
Message-ID: <DCr55u.CB9_at_twisto.eng.hou.compaq.com>#1/1
> Hi all!
>
> When I wrote a row-level triggers in Oracle I frequently need to pass a whole
> set of record fields values to a procedure. But I can't. :new and :old is only
> referencing, they aren't treated as real records by Oracle. If I wrote
> somewhere in the trigger
>
> my_procedure(:new)
>
>
> then PL/SQL cry : "Invalid binding variable."
>
> Why ?!
>
> And why I can SELECT whole record but can't INSERT it?
> Are there any real reasons ?
>
> Does Oracle plan to solve this problems,
> does anybody know ?
>
>
>
> Alexandr Alesinsky,
> JSV Investor
>
>
>
I am having the same problem. Oracle, at this time doesn't hold this as a "must" enhancement. We are also looking for them to allow record inserts using the RECORD type variables.
Date: 1995/08/03
Message-ID: <DCr55u.CB9_at_twisto.eng.hou.compaq.com>#1/1
"Alexandr I. Alesinsky" <al_at_investor.kharkov.ua> wrote:
>
> Hi all!
>
> When I wrote a row-level triggers in Oracle I frequently need to pass a whole
> set of record fields values to a procedure. But I can't. :new and :old is only
> referencing, they aren't treated as real records by Oracle. If I wrote
> somewhere in the trigger
>
> my_procedure(:new)
>
>
> then PL/SQL cry : "Invalid binding variable."
>
> Why ?!
>
> And why I can SELECT whole record but can't INSERT it?
> Are there any real reasons ?
>
> Does Oracle plan to solve this problems,
> does anybody know ?
>
>
>
> Alexandr Alesinsky,
> JSV Investor
>
>
>
I am having the same problem. Oracle, at this time doesn't hold this as a "must" enhancement. We are also looking for them to allow record inserts using the RECORD type variables.
Kim Hughes
DRT Systems International
Houston, TX 77008
Received on Thu Aug 03 1995 - 00:00:00 CEST