| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Closing cursors |
« View previous topic :: View next topic » |
| Author |
Message
|
| brokerDev |
 Posted: Thu Jan 25, 2007 7:16 am Post subject: Closing cursors |
 |
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi,
We are using broker v5 on a unix platform. We want to call an oracle stored proc that's using cursors. Does broker automatically close the cursor as part of the procedure call or do we have to close the cursor explicitly?
Thanks |
|
| Back to top |
|
 |
| mgk |
| Posted: Thu Jan 25, 2007 11:12 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
It depends what you mean by "using cursors". ESQL will close all the cursors it opens, but if the procedure returns more than one result set then you cannot use that in V5. V6 supports stored procedrues returning multiple result-sets if that is what you are trying to do. If you post your procedrue definition that would help.
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Thu Jan 25, 2007 1:46 pm Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
The stored procedure has the following as parameters -
spoolRequests( firstParam IN VARCHAR2 DEFAULT NULL
,secondParam IN VARCHAR2 DEFAULT NULL
,thirdParam IN DATE DEFAULT NULL
,fourthParam IN DATE DEFAULT NULL
,fifthParam IN xxx%TYPE
,rtnCursor OUT Types.xxx
,rtnParam2 OUT NUMBER
,rtnParam3 OUT VARCHAR2 )
I will post the procedure definition shortly... |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
