| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling stored procedure using ESQL problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| wmqstankela |
 Posted: Fri Apr 01, 2016 5:34 am Post subject: Calling stored procedure using ESQL problem |
 |
|
Voyager
Joined: 29 Feb 2016
Posts: 94
|
Hi all,
I need some help. I'm trying to call stored procedure from compute node with this code
| Code: |
CALL get_wfm_tts_status(p1,p2, tts_status, tts_reason);
CREATE PROCEDURE get_wfm_tts_status(IN p_wfm_status CHAR, IN p_wfm_reason CHAR, OUT p_tts_status CHAR, OUT p_tts_reason CHAR)
LANGUAGE DATABASE
EXTERNAL NAME "get_wfm_tts_status"; |
my stored procedure is like:
| Code: |
| get_wfm_tts_status(p_wfm_status in varchar2, p_wfm_reason in varchar2, p_tts_status out varchar2, p_tts_reason out varchar2) |
I'm having this error: Data source name not found and no default driver specified
I wrote data source name into property of compute node, name of configurable service that i using to connect on database
How to say compute node in witch database to look for this store procedure, and how to connect to this database?
Can anyone help me? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Apr 01, 2016 5:48 am Post subject: Re: Calling stored procedure using ESQL problem |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmqstankela wrote: |
| I wrote data source name into property of compute node, name of configurable service that i using to connect on database |
Where in the documentation does it say that the Compute node uses a configurable service to connect to the database?
| wmqstankela wrote: |
| How to say compute node in witch database to look for this store procedure, and how to connect to this database? |
As described in the documentation 
| wmqstankela wrote: |
| Can anyone help me? |
You could have helped yourself faster - that link was the first hit I got after typing "connect compute node to database" in the InfoCenter search. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
