Subject | Re: [ib-support] Firebird Workbench, EXECUTE Stored Procedure within another Stored Procedure. |
---|---|
Author | Martijn Tonies |
Post date | 2003-01-09T12:08:11Z |
Hi Henrik,
Me again :)
--8<-- snip
btw, if you use SUSPEND, you should use SELECT.
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."
Me again :)
> I'm trying to execute a stored procedure within another storedThis procedure returns a couple of parameters.
> 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
--8<-- snip
> My second Stored procedure is:Where does this get it's return parameters??
>
> SET TERM ^! ;
> CREATE PROCEDURE TEST2 AS
> BEGIN
>
> EXECUTE PROCEDURE TEST1 ;
btw, if you use SUSPEND, you should use SELECT.
> END ^!With regards,
> 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"
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."