Subject Re: [ib-support] Firebird Workbench, EXECUTE Stored Procedure within another Stored Procedure.
Author Martijn Tonies
Hi Henrik,

Me again :)

> I'm trying to execute a stored procedure within another stored
> procedure. The first procedure looks like this:
>
> SET TERM ^! ;
> CREATE PROCEDURE TEST1 returns (VAR_VARETYPE VarChar(50), VAR_LEVERANDOR
> VarChar(50), VAR_ADRESSE1 VarChar(50), VAR_KONTAKTPERSON VarChar(50),
> VAR_TELLER Integer) AS

This procedure returns a couple of parameters.


--8<-- snip

> My second Stored procedure is:
>
> SET TERM ^! ;
> CREATE PROCEDURE TEST2 AS
> BEGIN
>
> EXECUTE PROCEDURE TEST1 ;

Where does this get it's return parameters??

btw, if you use SUSPEND, you should use SELECT.

> END ^!
> SET TERM ; ^!
>
> So my plan is simply to execute TEST1 in TEST2, but I get the following
> error: "ISC ERROR MESSAGE: invalid request BLR at offset 24 parameter
> mismatch for procedure TEST1"


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."