| Author |
Message
|
| jonny |
 Posted: Fri Oct 01, 2004 5:58 am Post subject: WBIMB - CSD03 - Stored Procedures |
 |
|
Acolyte
Joined: 03 Jul 2003
Posts: 57
|
Hi,
I am trying to call a Sybase stored procedure using WBIMB - CSD03, here is my ESQL:
--------------------------------------
CREATE DATABASE MODULE test
DECLARE Input CHAR;
CALL test_proc( Input);
CREATE PROCEDURE test_proc (
IN Input CHAR
) EXTERNAL NAME test_proc
---------------------------------------
But I am getting a syntax error in the Toolkit ESQL editor. The error is pointing to the CALL line, and the error is:
Routine "AddPatient" is not declared for for these argument
Any idea what the problem is ???
Thanks in advance |
|
| Back to top |
|
 |
| mgk |
| Posted: Fri Oct 01, 2004 6:17 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
Try searching for a routine called AddPatient and removing it, then resave your ESQL file.
The following code (almost the same as yours, the main diffference is you had a missing semi-colon on the CREATE PROCEDURE) shows no errors in my WMBIMB V5 CSD4 tooling
| Code: |
CREATE DATABASE MODULE Fred_Database
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE Input CHAR;
CALL test_proc( Input);
RETURN TRUE;
END;
CREATE PROCEDURE test_proc (
IN Input CHAR
) EXTERNAL NAME test_proc;
END MODULE; |
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 |
|
|
| jonny |
| Posted: Fri Oct 01, 2004 6:30 am Post subject: |
|
|
Acolyte
Joined: 03 Jul 2003
Posts: 57
|
Well actually I wasn't missing semi-colon, I just forgot to add it in the post. And the error message was:
Routine "test_proc" is not declaredfor these arguments. The problem is solved now, I just recreated the message flow and I don't get that syntax error anymore.
Thanks for your help |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Oct 01, 2004 6:43 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hmmmm...
| jonny wrote: |
| Well actually I wasn't missing semi-colon, I just forgot to add it in the post. |
So I'm supposed to read your mind?
_________________
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 |
|
|
| jefflowrey |
| Posted: Fri Oct 01, 2004 8:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| mgk wrote: |
So I'm supposed to read your mind?
|
I think IBM has an adapter for that... but the installation process is very complicated...
  
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
