DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: An Urgent help Please..

  1. #1
    Join Date
    Apr 2001
    Posts
    14

    Lightbulb

    Hi,
    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
    Posts
    153
    Hi

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

    Vijays
    Vijay.s

  3. #3
    Join Date
    Apr 2001
    Posts
    14
    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