This message could be comming from the tool you are using to compile the
procedure. In IB_ISQL there is a check box that will treat :ID as a
local variable and expect the local variable to be declared.

At 06:15 PM 5/22/02 +0100, you wrote:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>