As long as the initial_caps_proc doesn't have a suspend statement, it will
basically be seen as a function call. To use it to update records one time:

Update MyTable set Column_A = (select OutVar from
initial_caps_proc(Column_A)), Column_B = (select OutVar from
initial_caps_proc(Column_B));

I haven't tested this but it should work if memory serves me correctly. :)

Woody (TMW)


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

> 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' )
>