|Subject||Re: [firebird-support] Re: How to call a STORED PROCEDURE in SQL statement : select ProcA(col1) from ..|
> Thanks for the quick feedback.Actually, RETURNS can hold multiple returning values (output parameters)
> When you say that a procedure is NOT a function, you forgot that what
> is called "STORED PROCEDURE" in FIREBIRD can actually returns values
> like a standard programming language function:
> CREATE PROCEDURE procA (inputPar INTEGER)
> RETURNS (outputPar INTEGER)
> AS BEGIN
> And you call it
> EXECUTE PROCEDURE procA(25) RETURNING_VALUES var1;
while in any language, a function only returns a single result value. So
not at all the same as a function that, for example, can be called like:
var1 = procA(25);
like any built in function or UDF.
> FIREBIRD would gain flexibility if we could create functions based onAgreed. Stored Functions have been long on my list of wanted features,
> PSQL avoiding the need to rely on non-portable and potentially
> dangerous UDF.
but as I don't do the roadmap for Firebird, I can't help you when or how
they are implemented.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!