View Single Post
  #1 (permalink)  
Old 08-13-10, 00:00
tiger66 tiger66 is offline
Registered User
 
Join Date: Dec 2007
Posts: 32
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
Reply With Quote