Re: Calling Stored Procedures

Anthony Robinson <[EMAIL PROTECTED]> wrote:

> I'm executing a stored procedure and getting the
> SQL0440N No authorized routine named
> "AMROBI2.CREATEAIMCONNECTION" of type "PROCEDURE
> " having compatible arguments was found.
> 
> Here's the stored procedure body (pretty basic):
> CREATE PROCEDURE AMROBI2.CreateAIMConnection (IN decCHANNELSESSIONID
> DECIMAL(12,0),
> IN strBUSINESSLINE VARCHAR(24),
> IN strBRANCHID VARCHAR(24),
> OUT decAIMCONNECTIONID DECIMAL(12,0))
[...]
> 
> CALL AMROBI2.CREATEAIMCONNECTION (5, 'TEST', 'TEST');

Your procedure expects 4 parameters and you only provided 3.  But there is
no procedure with 3 parameters, so the error is correctly raised.

You should call the procedure like this:

CALL AMROBI2.CREATEAIMCONNECTION (5, 'TEST', 'TEST', ?);

-- 
Knut Stolze
Information Integration
IBM Germany / University of Jena