I want to execute sql cursors in
JSP.
I do something like this and its not working.
stmt.executeQuery("BEGIN work; DECLARE item_cursor CURSOR FOR SELECT user_name FROM admin_info; FETCH 10 FROM item_cursor; CLOSE item_cursor; COMMIT work;");
database that im executing that on is postgres.
Dose anybody has a pice of code that works?
I need this aspa THANKS