| Author |
Message
|
| aaron_blade |
 Posted: Fri Jan 01, 2010 6:45 pm Post subject: WMB - Accessing Stored Procedures in compute node |
 |
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
Hi,
I am trying to get results from Stored Procedure. I am using compute node.
Steps I followed :
Calling StoredProcedure in main module and wrote create storedprodure where I am passing parameters to the procudure.
I am getting the following error:
The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored porocedure.
Can anyone help me out how to get the values from stored procedures.
-Thanks,
Raj.. |
|
| Back to top |
|
 |
| WMBDEV1 |
| Posted: Sat Jan 02, 2010 6:32 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| Why dont you show the stored procedure defintion and the ESQL that calls it? That may help |
|
| Back to top |
|
|
| napier |
| Posted: Mon Jan 04, 2010 2:13 pm Post subject: |
|
|
Apprentice
Joined: 09 Oct 2007
Posts: 48
Location: USA
|
There were different ways to write stored procedure on DB side.
You have to talk with yous DB developer and look at the backend stored procedure. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Jan 04, 2010 9:52 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
are you getting the same error if you execute or call the stored procedure from TOAD/SQL Developer/Command prompt.
Cross check the input parameters data types also.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| ak |
| Posted: Mon Jan 25, 2010 2:52 am Post subject: |
|
|
Apprentice
Joined: 07 Aug 2006
Posts: 48
Location: England
|
| Change your OUT parameters to INOUT especially if you are using MS SQL Server as your database. |
|
| Back to top |
|
|
| WMBEAI |
| Posted: Mon Jan 25, 2010 4:32 am Post subject: |
|
|
Acolyte
Joined: 02 Mar 2009
Posts: 66
|
check the datatypes of ur IN and INOUT parameters.
Check if the arguments you pass for the CALL of the stored procedure matches with the CREATE STORED PROCEDURE . |
|
| Back to top |
|
|
|
|
