Hi,
I am trying to setup an adapter notification that calls a store procedure in Oracle 10g. The store procedure has only OUT parameter of type REF CURSOR. Whatever I do I am not able to get the whole resultset returned in the notification publishable document. It allways returns only one row which is not acceptable for me. When I setup a regular adapter service for calling that stored procedure, it returns the whole resultset, but if I call it from the notification service - It wont return more than one row! Am I doing something wrong or just there is a bug in JDBC Adapter? Could anybody tell me whether you have done this with adapter notification?
My IS is 7.1, JDBC Adapter is 6.5, DB is Oracle10g, IS server is running on Solaris.
Thanks!
#Adapters-and-E-Standards#Integration-Server-and-ESB#webMethods