I'm trying to create a procedure, part of which is shown below, but I
cannot get it to compile. It throws an error on "INTO
mailing_address_indicator;" complaining that mailing_address_indicator
is an unknown column if I don’t prefix it with a : or "token unknown ?"
if I do.

I must be doing something stupid but I cannot see what. Any ideas?

RECREATE PROCEDURE TEST (ID Integer) returns (TITLE VarChar(150))
AS
DECLARE VARIABLE mailing_address_indicator VARCHAR(150);
BEGIN
SELECT DATAVALUE
FROM ATTRIBUTES
WHERE CONTACTID = :ID
AND ATTRIBUTEKEY = 506 /* Address Indicator */
INTO mailing_address_indicator;
...
...
END

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.361 / Virus Database: 199 - Release Date: 07/05/2002