Sending parameters to an Stored Procedure from Java.
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 !