| Author |
Message
|
| madhansathiyamoorthi |
 Posted: Tue Dec 30, 2014 4:39 am Post subject: ORA-01006: bind variable does not exist |
 |
|
Newbie
Joined: 30 Dec 2014
Posts: 4
|
Hi
I am trying to call ORACLE stored procedure
Oracle Proc:
PROCEDURE Name_Search(
inpar1 IN INTEGER,
outpar1 OUT INTEGER,
Record1 OUT data_Cur,
outpar2 OUT INTEGER,
outpar3 OUT VARCHAR2,
outpar4 OUT TIMESTAMP);
**Note data_Cur is a record set
ESQL CODE:
Procedure:
CREATE PROCEDURE PROC_CALL (IN inpar1 INTEGER,OUT outpar1 INTEGER,OUT outpar2 INTEGER,OUT outpar3 CHARACTER,OUT outpar4 TIMESTAMP)LANGUAGE DATABASE DYNAMIC RESULT SETS 1 EXTERNAL NAME "mySchema.myPkg.myProc";
CALL:
CALL PROC_CALL(inpar1,outpar1,outpar2,outpar3,outpar4,Environment.ResultSet[]);
i am getting below error
[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-01006: bind variable does not exist
Can some one help me?
Thanks in advance |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Dec 30, 2014 6:12 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Sadly your method signatures do not seem to match... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| madhansathiyamoorthi |
| Posted: Tue Dec 30, 2014 6:47 am Post subject: |
|
|
Newbie
Joined: 30 Dec 2014
Posts: 4
|
| fjb_saper wrote: |
| Sadly your method signatures do not seem to match... |
I am not able to find the difference can you please help me |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Dec 30, 2014 12:01 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| Sadly your method signatures do not seem to match... |
I am not able to find the difference can you please help me |
order matters?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| madhansathiyamoorthi |
| Posted: Tue Dec 30, 2014 7:01 pm Post subject: |
|
|
Newbie
Joined: 30 Dec 2014
Posts: 4
|
| fjb_saper wrote: |
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| Sadly your method signatures do not seem to match... |
I am not able to find the difference can you please help me |
order matters? |
You are right I think I hav placed all in same order except the result set which should be defined last. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Dec 31, 2014 6:11 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| Sadly your method signatures do not seem to match... |
I am not able to find the difference can you please help me |
order matters? |
You are right I think I hav placed all in same order except the result set which should be defined last. |
Is returning a cursor the same as returning a result set ??
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| madhansathiyamoorthi |
| Posted: Wed Dec 31, 2014 6:28 am Post subject: |
|
|
Newbie
Joined: 30 Dec 2014
Posts: 4
|
| fjb_saper wrote: |
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| madhansathiyamoorthi wrote: |
| fjb_saper wrote: |
| Sadly your method signatures do not seem to match... |
I am not able to find the difference can you please help me |
order matters? |
You are right I think I hav placed all in same order except the result set which should be defined last. |
Is returning a cursor the same as returning a result set ?? |
I am noy sure abt that. But I didnt find any way to get the cursor in stored proc to esql. Can please help me how this call esql procedure and call statement should be rewritten.
Thanks in advance |
|
| Back to top |
|
|
| wbisantosh |
| Posted: Tue Feb 24, 2015 5:49 pm Post subject: |
|
|
Apprentice
Joined: 12 Nov 2012
Posts: 47
|
Hello Madhan,
Were you able to get this Issue Fixed ? I am facing the same issue in my Local Windows 7 Environment. I imported the applications which is working perfectly fine in AIX and when I try to call a Stored PROC from WMB, I am facing the same issue.
Environment -
WMB 7.0.0.6
Windows
mqsicvp Connects fine
Thanks
Santosh |
|
| Back to top |
|
|
| nelson |
| Posted: Tue Feb 24, 2015 6:27 pm Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| wbisantosh wrote: |
Hello Madhan,
Were you able to get this Issue Fixed ? I am facing the same issue in my Local Windows 7 Environment. I imported the applications which is working perfectly fine in AIX and when I try to call a Stored PROC from WMB, I am facing the same issue.
Environment -
WMB 7.0.0.6
Windows
mqsicvp Connects fine
Thanks
Santosh |
Have you enabled "Procedure Return Results" option in your Windows DSN configuration? |
|
| Back to top |
|
|
| wbisantosh |
| Posted: Wed Feb 25, 2015 4:23 am Post subject: |
|
|
Apprentice
Joined: 12 Nov 2012
Posts: 47
|
Thank You Nelson. That did resolve the issue.
Santosh |
|
| Back to top |
|
|
|
|
