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

Deal it in java

Is there a way to do it in stored procedure?
I am not allow to do it in java