Hi to all.

I'm writing a stored procedure like this:

CREATE PROCEDURE get_cbxpar_data (
p_tabla varchar(10),
p_codigo varchar(2))
RETURNS (my_data varchar(64))
AS BEGIN
FOR SELECT descripcion
FROM m_cbxpar
WHERE tabla = :p_tabla AND codigo = :p_codigo
INTO :my_data
DO
SUSPEND;
END

But when I execute this statement:

SELECT ctaid, my_date, some_data, get_cbxpar_data ('IndEstAct', '1')
FROM my_table;

Raises a SQL error code = -804
Function unknown
GET_CBXPAR_DATA

What am I doing wrong?

Any help will be appreciated,

Nando.