I have a weird situtation where in the service end up returning null results when calling a SP thats supposed to return some values. I am using wM 6.1, Oracle 10g and JDBC Adapter.
I was calling a SP which returns the cursor as output. When I was calling this SP for the first time, it was returning the cursor with all the values from the desired table. But when I was calling the same procedure for the second time or further, the cursor wasnt returning any data. Using Local_Transaction and oci driver type in the configuration settings and does these settings have anything to do with that? anyone come across a situation like this??
appreciate your responses.