Hi,

i'm using firebird 1.5.3 and IBExpert 2006.08.16. I'm a newbie on
firebird and i have a problem with the stored procedures.

I have tried to implement procedures in firebird. They are compiled
without any problem and i can use them in a select statement. But the
result is always NULL.
For example this simple procedure:

-----------------------------------------------
CREATE PROCEDURE TEST
returns
(
result integer
)
as
BEGIN
Result = 1;
END;
-----------------------------------------------

I've made an select in this way:

select * from TEST;


And the result is NULL. When i debugg, the variable is correctly
filled.

What is going wrong?Do i forget something?

Thanks a lot!