--- You wrote:

> CREATE PROCEDURE SERIALY (
> SCHL Varchar(5),
> YAR Varchar(4) )
> RETURNS (
> VAL Smallint )
> AS
> ...
>
> I have keep getting error on EXECUTE PROCEDURE serialy

('0404','2007') RETURNING_VALUES (:VAL). The error message is

Try:

select VAL
from serialy ('0404','2007');


--

Milan Babuskov
http://www.guacosoft.com