DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2001


    Can any one please help me in building a Procedure to take an Array/Type or PL/SQL table as Input parameter and also return the Result set in Aray/Type or PL/SQL table as Out Parameter.

    Actually It's nature is Like some of the parameters would be single values and some of them in Array... Suppose a Procedure Pro_EmpInfo takes Parameters as Deptno, Ename, Job and should return every Thing from emp table into an Array/Type or Pl/SQL table as in Out parameter.

    Deptno is single value but the Ename, Job would be in Array/PL/SQL table becuase these value will be passed by the Java ... These value wil be passed like 100 enames, 10 Jobs but deptno=10

    Can any one please hep me out in this.. and also need to Know how will we execute that in SQL Plus ...

    I'll be very Thanks ful...
    Well Appreciated.

    Thanks in Advance.

  2. #2
    Join Date
    Jan 2001

    First of all the approach would be better if u use the Ref Cursor. Anyway i assumed that u r using oracle 8i !!! Try using Refcursor rather than using PL/SQL Table..


  3. #3
    Join Date
    Apr 2001
    Thanks for Your reply. Currently we are using Ref Cusrsor, but Now I have to give an Array or Pl/SQL Table as In Parameter...

    Any Clue ... Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.