JDBC Adapter: stored procedures + cursors

masrudyn.32323 · October 14, 2002, 5:17am

Hi…

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?

externe.fdosreis.18000 · October 15, 2002, 7:29am

Hi,

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.
Frederic.

masrudyn.32323 · October 16, 2002, 12:28am

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

suneetha.puppala.36247 · September 4, 2006, 5:03am

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