On Mon, Jun 20, 2011 at 8:41 PM, SoftTech <miket@...> wrote:

> **
>
>
> 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]
>
>
>

Try

SELECT some_data
FROM get_cbxpar_data ('IndEstAct', '1')

You will need to do a join to get at the other columns ctaid and some_data

Hope this helps.

--
Thomas Clarke
Cyber Sea Incorporated
#6 Kingston Terrace
Flint Hall
St. Michael
Barbados BB11070

voice: (246) 234-9692
email: tclarke@...
web: http://cybersea.biz


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