That same script is working fine here.Did you try it in the script of
ib_wisql??
I tried in ib_wisql script.There is no error in this syntax.

Sivaraman


At 11:26 AM 11/02/2003 +0000, you wrote:

>Hi Guys,
>I was going thru Stored Procedures...
>I have a TempDrs table which has only one field called DR_ID which is
>of VARCHAR(50) so I wrote a small SP like...
>
>set term ^ ;
>create procedure GETDRID_TEMP( sDRID varchar(50) )
>returns ( rDRID varchar(50) ) as
>begin
> For select DR_ID from TEMPDRS where (DR_ID = :sDRID) into :rDRID
> do Suspend;
>end ^
>set term ; ^
>
>but am unable to create it.. can anybody help ???
>
>pls am waiting for your feedback.
>
>Kiran Kumar.
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.