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...
Thanks in Advance.
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..
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