Hi
I am listing out the problem I am facing while EXECUTING the function .
create table newtest (name varchar(50), address varchar(50))
CREATE FUNCTION newtestfunc () RETURNS setof varchar AS
'SELECT name,address FROM newtest'
LANGUAGE 'SQL';
select newtestfunc()
The output is 168269272 ,
in this table there are two records and the output is also coming twice There is no change in the number 168269272 ,168269272
Please guide me how to get the result set through a java bean
My Requirement :
1.I want to retrieve multiple records from the table using function. The function call will come from the java bean.
2. The table will have different datatypes.
Thanks