I would like to pass an argument to my java method such as a String to point to a specific resultset to return.

public static ResultSet read(String resultSetIDToReturn){ ...}

how do i have to change this example to make it works ? :

CREATE FUNCTION externalEmployees
()
RETURNS TABLE
...

Do you mean, how do you declare the argument to your function? You
declare it inside those parentheses:

  CREATE FUNCTION externalEmployees
  (resultSetIDToReturn varchar(128))
  RETURNS TABLE

thanks,

bryan


Reply via email to