| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling Overloaded Oracle Stored procedures |
« View previous topic :: View next topic » |
| Author |
Message
|
| bobbee |
 Posted: Thu Jan 08, 2009 3:35 pm Post subject: Calling Overloaded Oracle Stored procedures |
 |
|
Knight
Joined: 20 Sep 2001
Posts: 545
Location: Tampa
|
| We are using JDBC, as there is a stated ESQL restriction on this, to call an overloaded stored procedure. WE have two SP with the same name, one with 22 parameters and another with 26. The call can see the 22 version but when we pass 26 we get an SQL exception. Any comments. Is it the number of parameters or through WMB does this just not work? |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Jan 08, 2009 7:09 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi bobbee,
Could you paste the Exception Tree please.
Regards. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Jan 09, 2009 12:57 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Also, if you could put the procedures in different packages and/or schemas then you could call them from ESQL. The restriction only applies to procedures in the same schema and package...
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 |
|
|
| bobbee |
| Posted: Fri Jan 09, 2009 7:15 am Post subject: |
|
|
Knight
Joined: 20 Sep 2001
Posts: 545
Location: Tampa
|
The real e.exception was tremendously BIG I hope this does the trick.
-------------------------------------------------------------------------------
"e"= SQLException (id=67)
cause= SQLException (id=67)
detailMessage= "[Oracle][ODBC]Syntax error or access violation."
next= null
SQLState= "37000"
stackTrace= StackTraceElement[6] (id=72)
vendorCode= 0
walkback= int[6] (id=75)
----------------------------------------------------------------------------------- |
|
| 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
|
|
|
|
