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, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.