Обсуждение: dynamic queiries

Hi,

A am trying to execute following query..:

 strSelectString := ''SELECT OBJID2 as strPersonnummer FROM '' ||
strRollentab || ''
                            where qualitaet = ''|| QUALITAETNR ||''
                            AND OBJID2 = '' || NEW.ID || '''';

How do I go about it?
I tried with normal execute, but no luck..

        EXECUTE ''SELECT OBJID2 as strPersonnummer FROM '' ||
strRollentab || ''
                            where qualitaet = ''||
quote_literal(referrer_keys.QUALITAETNR) ||''
                            AND OBJID2 = '' || NEW.ID || '''';

and i tried with For-in-execute, as stated in the docus, but no luck either.
I receive an error message stating that the sql statement is missing
something.

        FOR ROW IN EXECUTE strSelectString LOOP
            Raise NOTICE ''result: % '',strPersonnummer;
        END LOOP;


How can I do this then??

Thanks!!


 Carla Correia

This e-mail and any attachment is for authorised use by the intended recipient(s) only.  It may contain proprietary
material,confidential information and/or be subject to legal privilege.  It should not be copied, disclosed to,
retainedor used by, any other party.  If you are not an intended recipient then please promptly delete this e-mail and
anyattachment and all copies and inform the sender.  Thank you.