| Author |
Message
|
| Herbert |
 Posted: Tue Jul 14, 2009 2:02 am Post subject: Oracle procedure overloading not working with WMB |
 |
|
Centurion
Joined: 05 Dec 2006
Posts: 146
Location: Leersum, The Netherlands
|
Hi,
I have problems calling a Oracle stored procedure from WMB, the Error is:
BIP292: The procedure <insert_1> with <insert_2> parameters could not be matched with a corresponding Database stored procedure.
The procedure is 3 times defined in the Oracle database with 3, 4 and 6 parameters. The one with 6 parameters is the right one, if I a remove the other 2 procedures from the Oracle database then it is working fine. All 3 procedures are placed in the same package.
The versions used are:
WMB: 6.0.0.7
Oracle: 10.2.0.1.0
Kind Regards, Herbert |
|
| Back to top |
|
 |
| vmcgloin |
| Posted: Tue Jul 14, 2009 2:08 am Post subject: |
|
|
Knight
Joined: 04 Apr 2002
Posts: 560
Location: Scotland
|
Hi,
The first entry in the message broker help when you search for 'oracle stored procedure' states:
"Overloaded procedures are not supported. ... If the broker detects that a procedure has been overloaded, it raises an exception. "
Cheers,
Vicky |
|
| Back to top |
|
|
| Herbert |
| Posted: Tue Jul 14, 2009 3:11 am Post subject: |
|
|
Centurion
Joined: 05 Dec 2006
Posts: 146
Location: Leersum, The Netherlands
|
| vmcgloin wrote: |
The first entry in the message broker help when you search for 'oracle stored procedure' states:
"Overloaded procedures are not supported. ... If the broker detects that a procedure has been overloaded, it raises an exception. " |
oops, a RTFM, I'm sorry, thanks for your help, Herbert |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed Jul 15, 2009 7:41 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
| But would it work (invoking overloaded procs) if called from a JCN ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 15, 2009 9:31 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| jbanoop wrote: |
| But would it work (invoking overloaded procs) if called from a JCN ? |
Not with the ODBC connection! 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed Jul 15, 2009 9:34 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
Ok. So if we use JDBC (basically just use java features without any MB given funtionality) it should work.
Thanks. |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Thu Jul 16, 2009 12:35 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| jbanoop wrote: |
Ok. So if we use JDBC (basically just use java features without any MB given funtionality) it should work.
Thanks. |
Just make sure the rollback / commit works properly depending on the outcome of the flow if you are managing the connection yourself. |
|
| Back to top |
|
|
|
|
