| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling Stored Procedure From Oracle through ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| contactop |
 Posted: Thu Sep 02, 2004 12:20 pm Post subject: Calling Stored Procedure From Oracle through ESQL |
 |
|
Acolyte
Joined: 26 Jun 2003
Posts: 50
|
I am calling a stored procedure from WBIMB through esql, from Oracle. Below is the details.
in the main i am writing this
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL WBIJCI_FA_SAP_INTERFACE_START();
return True;
end;
CREATE PROCEDURE WBI_FA_SAP_INTERFACE_START()
EXTERNAL NAME "APPS.FA_SAP_INTERFACE_START_1";
But, i see the configmgr goesdown. And teh system hangs. Would u suggest what to do. |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Sep 03, 2004 10:52 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
When does the config mgr goes down? Do you see any errors in the event viewer related to this?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| contactop |
| Posted: Mon Sep 06, 2004 2:20 pm Post subject: |
|
|
Acolyte
Joined: 26 Jun 2003
Posts: 50
|
As soon as the procedure is been called, the configmgr goes down. The stored procedure , is not being called, also checked with teh Oracle DBA, the procedure is never been called.
So, the procedure is correct. Now, what should i do , to call the procedure from ESQL.
Thanks |
|
| Back to top |
|
|
| mgk |
| Posted: Mon Sep 06, 2004 11:57 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
If this is repeatable, rather than an isolated incident, please raise a PMR. This should not happen
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| mquser1 |
| Posted: Tue Sep 07, 2004 1:52 pm Post subject: |
|
|
Novice
Joined: 03 Jun 2004
Posts: 23
|
Is there a mismatch in your procedure names?
(between what you call and what you have defined)
WBIJCI_FA_SAP_INTERFACE_START()
WBI_FA_SAP_INTERFACE_START() |
|
| 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
|
|
|
|
