| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| REF CURSORS |
« View previous topic :: View next topic » |
| Author |
Message
|
| brokerDev |
 Posted: Mon Feb 05, 2007 3:12 am Post subject: REF CURSORS |
 |
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
I am trying to call an oracle stored proc from Broker
(Broker v5/AIX 5.3, Stored procedure on AIX 5.3/Oracle 10g)
The error I am gettingwhen I run in graphical debug mode is:
[DataDirect][ODBC Oracle driver][Oracle]ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'LISTOP' ORA-06550: line 1, column 8: PL/SQL: Statement ignored |
|
| Back to top |
|
 |
| brokerDev |
| Posted: Mon Feb 05, 2007 3:14 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
| Sorry, I'm getting an error when trying to post the rest of the message - "Service unavailable"... |
|
| Back to top |
|
|
| FraggleRock |
| Posted: Wed Feb 07, 2007 11:50 pm Post subject: Version 6 Broker and Oracle Reference Cursors |
|
|
Newbie
Joined: 20 Sep 2006
Posts: 4
|
I hit a similar problem when I set up my version 6 broker, but I think the functiuonality is pretty similar between 5 and 6.
Things to check:
Make sure the ODBC File has the EnabkeDescribeParam=1 this will allow for Reference Cursors to be returned.
See my last post about how I was able to call stored procedures with reference cusors.
http://www.mqseries.net/phpBB2/viewtopic.php?t=32166&highlight=
Final tip, turn on odbc tracing in the ODBC file if this still does not work. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Thu Feb 08, 2007 12:19 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Thanks FraggleRock.
I've resolved the problem. The solution is that we were on MB 5 (fix pack 7) and the drivers on that level do not allow pulling back data from a stored proc with a REF CURSOR parameter on an Oracle 10g DB.
We upgraded to CSD09 (which includes the V5 drivers) and was easily able to access the REF CURSOR. |
|
| 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
|
|
|
|
