JDBC Adapter: stored procedures + cursors


Are there any problems in using stored procedures which return cursors when using the JDBC adapter? I’ve got a webMethods consultant who said that he had seen problems with it before. What if the stored procedures returns many rows?


you can’t use JDBC adapter to call stored procedures which return cursors… with Oracle adapter it should work. The reason is that cursors are not defined in the JDBC standard (for the moment). hope this help.

Hi…Thanks for your reply. Yeap, that helps a lot! Have a nice day!

Currently i am using JDBC Adapter: stored procedures + cursors. cursors are working fine in 6.1 version with jdbc adapters also.