Hi,

I'm having trouble with this simple stored procedure:

SET TERM !! ;
CREATE PROCEDURE test_proc (d_date TIMESTAMP)
RETURNS (Result CHAR(50))
AS BEGIN
Result = CAST(d_date AS CHAR(50));
SUSPEND;
END !!
SET TERM ; !!

If I execute this statement it works fine:

"SELECT a.my_id, a.some_date, a.a_name, c.my_result FROM some_table a, test_proc(CAST('01/01/2011' AS TIMESTAMP)) c WHERE a.my_id < 10;"

But if I execute this other one it raises an exception.

"SELECT a.my_id, a.some_date, a.a_name, c.my_result FROM some_table a, test_proc(a.some_date) c WHERE a.my_id < 10;"

> ISC ERROR CODE:335544348
> no current record for fetch operation.

What am I doing wrong?

Thank your in advance for any help.

Hernando.