You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The error is reproduced only in Firebird 3.0.0 (in Firebird 2.5.x works fine)
Test steps:
1. Create procedure TESTPROC:
create or alter procedure TESTPROC
(
P1 integer
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1) into p11;
suspend;
end
2. Create procedure TESTPROC2 which uses TESTPROC
create or alter procedure TESTPROC2
(
P1 integer
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1) into p11;
suspend;
end
3. Add input parameter P2 to original TESTPROC and pass P2 in recursive call of TESTPROC
create or alter procedure TESTPROC
(
P1 integer,
P2 integer = 0
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1, :p2) into p11;
suspend;
end
CREATE OR ALTER PROCEDURE TESTPROC failed
Dynamic SQL Error
Input parameter mismatch for procedure TESTPROC
After reconnection step 3 works without errors.
The text was updated successfully, but these errors were encountered:
Submitted by: Vladimir Arkhipov (arkinform)
The error is reproduced only in Firebird 3.0.0 (in Firebird 2.5.x works fine)
Test steps:
1. Create procedure TESTPROC:
create or alter procedure TESTPROC
(
P1 integer
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1) into p11;
suspend;
end
2. Create procedure TESTPROC2 which uses TESTPROC
create or alter procedure TESTPROC2
(
P1 integer
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1) into p11;
suspend;
end
3. Add input parameter P2 to original TESTPROC and pass P2 in recursive call of TESTPROC
create or alter procedure TESTPROC
(
P1 integer,
P2 integer = 0
)
returns
(
P11 integer
)
as
begin
select p11 from testproc(:p1, :p2) into p11;
suspend;
end
CREATE OR ALTER PROCEDURE TESTPROC failed
Dynamic SQL Error
Input parameter mismatch for procedure TESTPROC
After reconnection step 3 works without errors.
The text was updated successfully, but these errors were encountered: