Performance and scalability: How to pass multiple values of one column to pl/sql procedure
- Posted by: Aruna Gopalakrishnan
- Posted on: November 06 2001 09:33 EST
I want to do the following,
PROCEDURE FILTER1 (PPLAN IN VARCHAR2,RSLT_SET IN OUT RSLT_PPLAN_OUT,ERRMSG OUT VARCHAR2)
In this, i have to pass multiple values to the PPLAN column
and inside the procedure, the column should used as follows,
select * from plan_table where plan_id in (PPLAN) AND .....
I have to PPLAN values from a servlet.
PPLAN is output of another procedure.
How can do this and please in mind performence and memory problems should not arise.
Any help on this would be appreciated.
Thanks in Advance
- How to pass multiple values of one column to pl/sql procedure by The Ugly One With The Jewels on November 08 2001 07:47 EST
You can use PL/SQL collections. Refer to the "Oracle8i JDBC Developer's Guide and Reference" - chapter 10, Working with Oracle Collections (http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.817/a83724/oraarr.htm#1000888)