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.

Topic		Replies	Views
Oracle Adapter Returning and closing Cursors webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	4	1907	April 2, 2021
Oracle Adapter Returning and closing Cursors Bis webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1991	April 2, 2021
Adapter Service and Cursors webMethods , Integration-Server-and-ESB , Flow-and-Java-services	6	1986	April 2, 2021
Nested Cursors in stored Proc supported by webMethods? webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1018	April 2, 2021
Calling stored proc with cursors in 4.6 JDBC Adapter? webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	2	1815	April 2, 2021

JDBC Adapter: stored procedures + cursors

Related topics