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.
