OK, I have a stored procedure that accepts an array of character strings as input. I can call it from IBM Data Studio quite easily by right clicking on the stored procedure in the explorer and choosing "run". I input the parameter as
And it runs just fine. Now I'd like to call the stored procedure from a SQL script, something like this
I even tried a global variable.
SET MY.VARIABLE = ARRAY['123','123','123']
The set works but the call fails.
Has anyone attempted this? The documentation seems to suggest that you can only pass an array from an array structure in a host variable, but that would be disappointing. I'll be trying the call from Java in the coming weeks but thought I'd reach out to see if anyone has had this experience.
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504