Referencing records field without hard-coding its name in PL/SQLcode

#1

is there any possibility to reference a record field in PL/SQL code, not
hard-coding it name

e.g.
i`ve got a ':new' record in a trigger and an array of varchar2 ` s -
this records fields names.
can access this record via names from the table ?

i mean something like

:new.get( 'fieldname' )
:new[ fieldnumber ]

anything.

thanks in advance for any response.

#2

"m_mis" <mPODKRESLENIEmis (AT) friko6 (DOT) onet.pl> wrote

Quote:

is there any possibility to reference a record field in PL/SQL code, not
hard-coding it name

e.g.
i`ve got a ':new' record in a trigger and an array of varchar2 ` s -
this records fields names.
can access this record via names from the table ?

i mean something like

:new.get( 'fieldname' )
:new[ fieldnumber ]

anything.

thanks in advance for any response.
I can't think of a way to do it in a trigger to be able to reference :new.

These are local variables to the trigger. If you did it in the way you
indicate then you would probably generate a lot of hard parses. This would
eat up a lot of CPU and a lot of latching.
Jim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Referencing records field without hard-coding its name in PL/SQLcode

comp.database.oracle comp.database.oracle

Referencing records field without hard-coding its name in PL/SQLcode - 07-12-2005 , 10:02 AM

Re: Referencing records field without hard-coding its name in PL/SQL code - 07-12-2005 , 09:48 PM