On 31/05/2021 11:39, Vlad Khorsun wrote: > 31.05.2021 16:19, Adriano dos Santos Fernandes wrote: >> Hi! >> >> EXECUTE PROCEDURE is full of weirdness, so I propose that standard SQL >> CALL is adapted for our needs. >> >> EXECUTE PROCEDURE [ <package> . ] <name> >> [ <value list> | ( <value list> ) ] >> [ RETURNING_VALUES <variable list> | >> RETURNING_VALUES ( <variable list> ) ] >> >> It does not allow one to "select" what just it wants. >> >> So if one changes the procedure output parameters, clients (DSQL and >> PSQL) needs to be changed. It's like "SELECT *" which is sure a bad >> practice. >> >> It has this weird RETURNING_VALUES and multiple syntax about parenthesis. >> >> It does not allow to just execute and ignore output parameters. > > As I see, all problems above is related with RETURNING_VALUES clause, > correct ? >
But then an EXECUTE PROCEDURE ignoring output will not be possible. Also, EXECUTE PROCEDURE is very verbose (specially for execute ignoring outputs, which in most languages does not even require any keyword - but is ambiguous with our functions). If CALL is not accepted, then I propose same syntax with "EXEC". Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
