Arrays as parameters to stored procedures

By: Quinn Wildman

Abstract: Arrays cannot be used as parameters to stored procedures

Q. Is there a way to pass an array to a stored procedure as a parameter?

A. In the InterBase language reference online book (langref.pdf), the section "Input Parameters" within the chapter "Procedures and Triggers" says: "Input parameters can be of any InterBase datatype except Blob. Arrays of datatypes are also unsupported."

So, unless your array is an array of datatypes, arrays may be used.

Server Response from: ETNASC04