Re: [Firebird-devel] Stored Procedure - BLOB input parameter => Internal error

[Martijn T. <m.t...@up...>]

Hi Thomas,

> is there anything wrong using BLOB input parameters for
> stored procedures?

Not that I know of.

but...

> CREATE PROCEDURE PRO_BLOBTEST
>   (ABLOB BLOB SUB_TYPE 1)

> Execute:
>
> select * from pro_blobtest(null); => works
>
>
> Execute:
>
> select * from pro_blobtest('dsfasfd'); => results in an
> "internal error".

'dsfasfd' isn't a BLOB.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com