Accept multiple values from Java into an PL/SQL procedure
Posted on 2009-04-06
I am writing a PL/SQL procedure which (in part) should accept a series of values from a Java front-end for for an item which should be used to limit values to return.
For example, my procedure might return a list of clients, and a user might want to see all clients, or only some clients from one or more states.
My PL/SQL procedure could accept a comma delimited string (eg. "ME,IA,NY,TX" which would return clients from Maine, Iowa, New York and Texas) , or an empty string to get back all clients fron all states.
I'm being told that my procedure could/should accept things called "collections" or "objects" which apparently would make it easier and/or better for the Java programmers.
Is this true, and if so, how should my parameters be coded and how can I strip out the values passed?