Subject | RE: [firebird-support] Can't execute a procedure that has a output parameter |
---|---|
Author | Helen Borrie |
Post date | 2008-09-13T05:30:17Z |
At 13:35 13/09/2008, you wrote:
P_COMPANY /* TYPE OF */ SMALLINT)
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
>I use Ibexpert 2008 , firebird 2.1CREATE OR ALTER PROCEDURE CMD_FILIFO_ENTRY(
>
> My procedure:
>
> CREATE OR ALTER PROCEDURE CMD_FILIFO_ENTRY(
>
> P_COMPANY TYPE OF SMALLINT) <------ bad syntax, try to correct it:
P_COMPANY /* TYPE OF */ SMALLINT)
>RETURNS (At the other procedure you should have a variable ready to receive the output, e.g.
>
> 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.
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