Thanks, but I don't want to receive returning value.



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Saturday, September 13, 2008 12:30
To: firebird-support@yahoogroups.com
Subject: [!! SPAM] RE: [firebird-support] Can't execute a procedure that has
a output parameter



At 13:35 13/09/2008, you wrote:

>I use Ibexpert 2008 , firebird 2.1
>
> My procedure:
>
> CREATE OR ALTER PROCEDURE CMD_FILIFO_ENTRY(
>
> P_COMPANY TYPE OF SMALLINT) <------ bad syntax, try to correct it:

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.

At the other procedure you should have a variable ready to receive the
output, e.g.

declare variable ivar smallint;
...

begin
....
execute procedure CMD_FILIFO_ENTRY(1)
returning_values (:ivar);
....
end

That is what Anderson Farias was trying to get you to tell us...

./heLen





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