Hi everyone,
I have some problems trying to use a preparedStatement with an array
parameter. The problem is I don't know how to do it :-(
CREATE OR REPLACE FUNCTION MyFunction( id INTEGER, anArray
VARCHAR[] )..........................
pstat = conn.prepareStatement("SELECT * FROM MyFunction(?,?)");
pstat.setInt(1, 30);
pstat.setArray(2, ??????????);
Can you tell me how can I construct the array for parameter number 2?
Thanks,
NosyMan