| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem calling oracle stored procedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| vasanthi |
 Posted: Thu Apr 06, 2006 1:52 pm Post subject: problem calling oracle stored procedure |
 |
|
Apprentice
Joined: 23 Apr 2005
Posts: 42
|
Hi
i am having problems calling an oracle stored procedure from my compute node.i am using WBIMB5.0.
I have got a stored procedure in oracle like
SM(IN YR INTEGER, IN PERIOD INTEGER, IN SA NUMBER, IN CLASS VARCHAR2);
But when i am trying to call this from my compute node
CALL SM(YR,PERIOD,SA,CLASS);
CREATE PROCEDURE SM(IN YR INTEGER, IN PERIOD INTEGER, IN SA DECIMAL, IN CLASS CHAR) EXTERNAL NAME "SS.SM";
I get an exception saying that the procedure is overloaded. but i have only one procedure with this name.oracle version is 9i.
Thanks
vasanthi |
|
| Back to top |
|
 |
| Srinu |
| Posted: Fri Apr 07, 2006 5:26 am Post subject: |
|
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Hi vasanthi ,
Try to use Language clause in Create Procedure statement by default takes ESQL u mention the language clause as Database and try
Srinu |
|
| Back to top |
|
|
| JT |
| Posted: Fri Apr 07, 2006 6:11 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| 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
|
|
|
|
