Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to change dynamically field name when using recordtype

Re: how to change dynamically field name when using recordtype

From: Andreas <anonmeg_at_start.no>
Date: Tue, 24 Feb 2004 20:25:49 +0100
Message-ID: <1BN_b.1518$EV2.7586@amstwist00>


Basant wrote:

> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1077520490.272671_at_yasure>...
...
> Hi,
> Above code was a sample code. I wrote with correct syntax in my program.
Correct syntax, but it does not do what you want to do... Your code will do this test: 'l_student.Name' = 'JOHN', which yields false... The code compares the strings!!! and does not access the l_student.Name variable.

You are probably thinking about something like java's introspeciton. I don't think that's possible in PL/SQL... You will probably need to interpret the logic in your REC_RULE table, and hard code the tests yourself.

Andreas Received on Tue Feb 24 2004 - 13:25:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US