Subject Re: Create procedure with an array input parameter
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
> Hi there,
>
> Is it possible to create a procedure with an input parameter
> that is an array datatype?
>
> eg:
> create procedure myarrayproc
> (
> myint int[4]
> )
> as
> begin
> suspend;
> end
>
> I'm getting an error message - but I'm unsure if this is because
> it isn't possible, or if it's because it's not the right syntax.

I took a look at the documentation I've got access to for Firebird 1.0
(Firebird Reference Guide, from IB-Phoenix), and it doesn't support
arrays in procedure parameters (as opposed to blobs and other
datatypes), at least not for CREATE PROCEDURE.

Firebird 1.5? Well, I haven't got a clue, check the release notes.

Set