Bad example code for SP default parameters [DOC29]

[firebird-issue-importer]

Submitted by: Ain Valtin (ain)

In FB 2.1 release notes, in chapter "Defaults for Stored Procedure Arguments" the example creates selectable stored procedure (named P1) and then executes it (ie EXECUTE PROCEDURE P1). Executing selectable SP isn't allowed (?) and thus the example is incorrect (or at least bad style).

[firebird-issue-importer]

Modified by: @paulvink

assignee: Paul Vinkenoog [ paulvink ] => Helen Borrie [ helebor ]

[firebird-issue-importer]

Commented by: @helebor

The OP is correct: this is not an example of sound PSQL programming practice. However, it should be obvious that the author used it in the examples to illustrate the working of the new feature. A comment was added to the article in the release notes.

[firebird-issue-importer]

Commented by: @helebor

But added a note that using SUSPEND in an executable SP is not recommended practice.

[firebird-issue-importer]

Modified by: @helebor

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]