Oracle Databases - Referencing records field without hard-coding its name in PL/SQL

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

m_mis

2005-07-12, 11:24 am

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.

Sponsored Links