How to pass multiple values of one column to pl/sql procedure

Discussions

Performance and scalability: How to pass multiple values of one column to pl/sql procedure

  1. Hi,

    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

    Aruna G



  2. 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)

    hth