SELECT * FROM GET_CBXPAR_DATA(:P_TABLA, :P_CODIGO)

Mike

----- Original Message -----
From: Nando
To: firebird-support@yahoogroups.com
Sent: Monday, June 20, 2011 6:39 PM
Subject: {Disarmed} [firebird-support] Firebird 1.5 - Stored procedure error 804



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.




--
MailScanner Virus/Spam/Malware: PASS (GZ)

[Non-text portions of this message have been removed]