Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Question Unanswered: Passing arrays into procedure

    Hi,

    Using Oracle 9i, I want to pass an array of values to a procedure. Then I wish to loop through the array to form a sql statements

    How do I do this array work in Oracle, such that I can pass

    1, 2, 5, 88, 2

    then loop through the list of values??

    Cheers!

  2. #2
    Join Date
    Oct 2003
    Posts
    71

    Re: Passing arrays into procedure

    Originally posted by kop
    Hi,

    Using Oracle 9i, I want to pass an array of values to a procedure. Then I wish to loop through the array to form a sql statements

    How do I do this array work in Oracle, such that I can pass

    1, 2, 5, 88, 2

    then loop through the list of values??

    Cheers!
    Sure, you can do it by using PL/SQL arrays (array_type)
    You will find help on it in PL/SQL reference guide.

  3. #3
    Join Date
    Mar 2002
    Posts
    20

    Re: Passing arrays into procedure

    Thanks, but no luck in locating what I require

    Do you have any examples that you can point me at?

  4. #4
    Join Date
    Oct 2003
    Posts
    71

    Re: Passing arrays into procedure

    Originally posted by kop
    Thanks, but no luck in locating what I require

    Do you have any examples that you can point me at?
    Not right now, but I will try to look for it.

Posting Permissions

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