-----Original Message-----

> From: firebird-support@yahoogroups.com

[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie

> Sent: Tuesday, September 04, 2007 7:05 PM
>
> -----------------------------
> Another way this SP would fail at runtime would be if you were

trying

> to pass a string in the NOTE parameter. A text blob and a string

are

> not interchangeable types. You have to pass a blob here; or,
> alternatively, change that input parameter to a varchar of 32,765 or

> less (for ascii, proportionately less for MBCS). You *can* pass a
> string as input to a text blob in your update statement.

Thanks Helen, that was the problem. I was able to change the type
from blob to varchar and everything works well.

Bob M..