| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database stored porocedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| apolireddy |
 Posted: Tue Sep 04, 2012 1:58 am Post subject: Database stored porocedure |
 |
|
Newbie
Joined: 04 Sep 2012
Posts: 5
|
Hi,
I am facing problem when ESQL PROCEDURE calling oracle stored proc.
ESQL stored proc.
CREATE PROCEDURE *********(
IN p1 CHARACTER, IN p2 CHARACTER,IN p3 CHARACTER,IN p4 CHARACTER)
--IN p1 CHARACTER, IN p2 CHARACTER,IN p3 CHARACTER,IN p4 CHARACTER)
LANGUAGE DATABASE
DYNAMIC RESULT SETS 1
EXTERNAL NAME "XXXXXXXXXXXXX";
this is the oracle stored proc
PROCEDURE XXXXXX(
P_START_POINT IN VARCHAR2,
P_START_DATE IN VARCHAR2,
P_PERIOD IN VARCHAR2,
P_NUM_OF_PERIODS IN VARCHAR2,
P_MESSAGE OUT VARCHAR2,
P_SQLQ OUT VARCHAR2,
RECORDSET OUT SYS_REFCURSOR,
P_Debug_Level IN number DEFAULT 0
);
i am getting this below error.
The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored porocedure.
I have created 2 different PROCEDURE. in one esql file to call different SP.
mb v8
Could you please help me on this. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Sep 04, 2012 2:27 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
set dynamic result sets to 2.
declare an in parameter for the debug flag. |
|
| Back to top |
|
|
| apolireddy |
| Posted: Tue Sep 04, 2012 2:38 am Post subject: |
|
|
Newbie
Joined: 04 Sep 2012
Posts: 5
|
Hi i did that but still i am facing same prob.
The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored porocedure.</Text> |
|
| Back to top |
|
|
| exerk |
| Posted: Tue Sep 04, 2012 3:16 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Moving this to a more appropriate forum. apolireddy, please take more care as to which forum you post in, thank you.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Sep 04, 2012 4:05 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The error is straightforward and basic.
The ESQL declaration of the procedure does not match the database declaration of the procedure.
I believe there are some issues with Oracle stored procedures that are overloaded - where Oracle knows about two different procedures with the same name but different argument lists. But you should research that, I may be remembering wrong.
Otherwise, you should make the ESQL procedure exactly match the definition of the procedure in the database. |
|
| Back to top |
|
|
| apolireddy |
| Posted: Wed Sep 05, 2012 1:43 am Post subject: Thank-you |
|
|
Newbie
Joined: 04 Sep 2012
Posts: 5
|
Thanks for you help and suggestions.
Regards,
Ayyappa |
|
| 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
|
|
|
|
