I have created a function to display the rows in a table. The function is returning the refcursor. I am calling the refcursor in Callable Statement, but i am getting No class found for refcursor. I have seen these queries earlier in this forum.
I am using postgresql 7.3.4 and pg74.215.jdbc3.jar.
As per the solutions given for earlier queries i tried to give getString(1), but i am getting null value.
i am attaching the code along with this mail.
This is my pl/pgsql
CREATE or REPLACE FUNCTION displayall() RETURNS refcursor AS ' DECLARE cursor1 cursor for select pageid,keyword from Maintable;