Hello, I am working with an Oracle 8.1.7 Database and there is a Java programmer in my company, I don't know which version is he using.

My question is: Is there a way to send an array created in Java, and receive it as a parameter in an Oracle Stored Procedure, and actually see it as a table? I have only sent individual parameters from Java to Oracle, like id's, names, and so on, but this time i need to receive a list of parameters, to be precise, it will contain a list of combinations of two different id's, CATEGORY_ID and SUBCATEGORY_ID. With each combination of these two parameters i will go look in a table for a third value.

Any help will be really appreciated, thanks a lot !