Subprocedures in PSQL and EXECUTE BLOCK [CORE1288]

[firebird-automations]

Submitted by: @kattunga

Is related to QA508

It's necessary to have subprocedures in PSQL because it's the only way to do a recursive procedure and some complex routines in EXECUTE BLOCK.
It would be useful too, to simplify some complex stored procedures without calling other procedures.

Commits: 0293c56 5ae632c FirebirdSQL/fbt-repository@fa4cfbb

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12232 ] => Firebird [ 15590 ]

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

This feature was just committed. They're very simple for now. No access to parent variables nor to call neighbour procedures.

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-automations]

Commented by: @hvlad

Does recursive sub-procedures really works ?

Try this

execute block
returns (n int)
as
declare procedure p2_sub(x int) returns (y int)
as
begin
if (x = 0)
then y = 0;
else begin
execute procedure p2_sub(:x-1) returning_values :y;
y = y * x;
end
end
begin
execute procedure p2_sub(5) returning_values :n;
end

The same concern about recursive sub-functions

[firebird-automations]

Commented by: @asfernandes

No, as I said, "They're very simple for now. No access to parent variables nor to call neighbour procedures.". Neither recursive calls.

[firebird-automations]

Commented by: @hvlad

Is it planned to be implemented in v3 ?

[firebird-automations]

Commented by: @asfernandes

It's not in my immediate plan, but may be.

Access to parent variables are priority IMO.

[firebird-automations]

Commented by: @kattunga

Thank you Adriano!, I was expecting this feature for a long time. it's a shame we can't get it in version 2.5.

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA508 [ QA508 ]