At 12:46 AM 21/03/2012, Kongthap Thammachat wrote: >Dear All > >I wanna create a stored procedure to return 'YYMM' of the current date >for using as part of my document ID > >This is my stored procedure PSQL so far > >SET TERM ^ ; >CREATE PROCEDURE P_YEARMONTH_PREFIX >RETURNS ( > YYMM Char(4) ) >AS >declare YY char(2); > declare MM char(2); >BEGIN > select substring(cast(extract(year from current_date) + 543 as >char(4)) from 3 for 2) > from rdb$database > into :YY; > > select cast(extract(month from current_date) as char(2)) > from rdb$database > into :MM; > > if (char_length(MM) = 1) then begin > MM = '0' || MM; > end > > result = YY || MM; -- why is this line get error
Because you have no variable named RESULT. You declared YYMM for your return value. ./heLen
