I use Ibexpert 2008 , firebird 2.1



My procedure:



CREATE OR ALTER PROCEDURE CMD_FILIFO_ENTRY(

P_COMPANY TYPE OF SMALLINT)

RETURNS (

REMAINING_AMOUNT smallint)

AS

BEGIN

-- do something, it is correct code here

END



At other procedure, I can't call EXECUTE PROCEDURE CMD_FILIFO_ENTRY(1);
Server throw an exeption: Output parameter mismatch CMD_FILIFO_ENTRY.

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Anderson Farias
Sent: Saturday, September 13, 2008 10:31
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can't execute a procedure that has a output
parameter



Hi,

>I wrote a procedure, it has a output parameter. But, I want to exec it
> without select: execute procedure cmd_fifo(). Server throw an exeption:
> Output parameter mismatch for cmd_fifo.

What exactly are you doing? What tools? Are you using returning_values to
get result parameters?

Regards,
Anderson Farias





[Non-text portions of this message have been removed]