• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL CURSOR  RSS feed

 
Peter Tomas
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!