Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    32

    Unanswered: pass in arrays as parameter in stored procedure

    Hi
    I have an array of values in java
    ie
    [name, type]
    [Bob, 1]
    [Sandy,2]
    [Tom, 3]

    I found out that sybase doesn't support array as paramenter and I need to construct the values into a string 'Bob,Sandy,Tom','1,2,3'

    I am just wondering, once I pass the strings into the stored procedure, is there an easy way to store the string in a temp table like
    Bob, 1
    Sandy,2
    Tom,3

    Thanks in advance for your help

  2. #2
    Join Date
    Nov 2002
    Posts
    21
    Deal it in java

  3. #3
    Join Date
    Dec 2007
    Posts
    32
    Is there a way to do it in stored procedure?
    I am not allow to do it in java

Posting Permissions

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