how to change dynamically field name when using recordtype

From: Basant <basantshanker_at_hotmail.com>
Date: 20 Feb 2004 05:37:18 -0800
Message-ID: <e3fbec7a.0402200537.68e00d46@posting.google.com>

Hi,
  I want to change the field name of a recordtype dynamically to compare two values. For Example.

   TYPE Rec IS RECORD (name VARCHAR2(300),

                       Roll  NUMBER);

   Student Rec;   

   FUNCTION isEqual (l_Student Rec,

                     ColumnName  VARCHAR2,
                     Value       VARCHAR2)
   BEGIN
     IF 'l_Student'||Columnname = Value THEN
       RETURN TRUE;
   ELSE
       RETURN FALSE; 

   END IF;
   END; Calling funciton as :

   l_Student Rec;
BEGIN
   l_Student.Name:='JOHN';
   isEqual(l_student,'.Name','JOHN');
END; I have already tried with Dynamic SQL . But didn't got any option to do like this.

Help me out...

Thanks in Advance.
Basant Received on Fri Feb 20 2004 - 07:37:18 CST