It's an internal procedure. I fixed my message file version issue and the error simply says:

SQL error code = -804
Function unknown
initial_caps_proc

However this works:

select * from initial_caps_proc( 'testing my test' )

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Woody
Sent: Thursday, October 10, 2013 10:59 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] for select stored procedure question



Is initial_caps_proc an external function or an internal procedure?

If it's an external function you need to make sure you declared it to the
database and the DLL is in the UDF directory.

It also looks like you might have a mismatched help file for FB since it's
showing you an @1 where something else should be.

Woody (TMW)

--------------------------------------------------
From: "Raith,Daniel" <draith@...>
Sent: Thursday, October 10, 2013 10:52 AM
To: <firebird-support@yahoogroups.com>
Subject: RE: [firebird-support] for select stored procedure question

> I tried using my stored procedure in an update statement like so:
>
> update MyTable
> set ColumnA = initial_caps_proc( ColumnA )
>
> but I get an error saying "function unknown. @1"
>
> Daniel
>
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Woody
> Sent: Thursday, October 10, 2013 10:43 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] for select stored procedure question
>
>
>
> From: Raith,Daniel<mailto:draith@...>
> Sent: Thursday, October 10, 2013 10:33 AM
> To:
> firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>
> Subject: [firebird-support] for select stored procedure question
>
> I want to write a stored procedure that updates two columns (all records)
> in a table to initial caps or camel case.
>
> For example: "testing a test" -> "Testing A Test"
>
>
>
> Why not just run a query to update the values if you only need to do it
> once?
>
> Update MyTable set column_A = initial_caps_proc(column_A), column_B =
> initial_caps_proc(column_B)
>
>
> if you really need a stored procedure that just returns the values and
> doesn't update them, then simply use this in the procedure:
>
> for select initial_caps_proc(column_A), initial_caps_proc(column_B) from
> myTable
> into :aa, :bb do
> suspend;
>
>
> Woody (TMW)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>

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