Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2009
    Posts
    88
    Rep Power
    0

    Default How to send a list as a input for a oracle procedure

    Hello i have a requirement to pass a list as a input for oracle stored procedure ?
    Plz provide me an example????

  2. #2
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    25

    Default

    I don't know the answer to your question, and if I did, I'd probably direct you to a tutorial or two, but I did want to commend you on an amazing posting history. It's simply incredible. Please keep up the good work!

  3. #3
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,442
    Rep Power
    18

    Default

    What's in the List?
    Presumably it's a List of a single class?

  4. #4
    Join Date
    Oct 2009
    Posts
    88
    Rep Power
    0

    Default

    List contain and object array..
    List list<Object[]>

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,442
    Rep Power
    18

    Default

    Then you have no hope.
    How could you write the stored procedure for starters?
    Oracle SPs cannot accept a parameter of AnyType.

Similar Threads

  1. Replies: 1
    Last Post: 10-18-2010, 07:14 AM
  2. Call Oracle procedure
    By take5 in forum JDBC
    Replies: 0
    Last Post: 06-01-2010, 10:18 AM
  3. Replies: 0
    Last Post: 02-03-2010, 08:20 AM
  4. Replies: 3
    Last Post: 10-14-2009, 09:32 AM
  5. How to call Oracle stored procedure from Java?
    By parag_narkhede in forum New To Java
    Replies: 4
    Last Post: 10-07-2009, 07:50 AM

Posting Permissions

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