Hello Stephen,

> Found a solution. I changed the stored procedure to return a VARCHAR
> rather than a blob and used the SUBSTRING to cast the BLOB to a VARCHAR.

There was also one bug fix related to BLOB not found and PSQL in
Firebird 2.0. Can't say for sure that an upgrade to 2.0 would cure the
problem in your scenario.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/