EXECUTE BLOCK and STORED PROCEDURE LANGUAGE and singleton execution
-------------------------------------------------------------------
Key: CORE-3695
URL: http://tracker.firebirdsql.org/browse/CORE-3695
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2,
2.0.5, 2.1.1, 2.1.0, 2.0.7, 3.0 Alpha 1, 2.1.5, 2.5.2, 3.0 Beta 1, 2.5.3,
2.1.6, 3.0.0
Environment: This is not an environment sensitive issue.
Reporter: Jason Wharton
Priority: Minor
When an execute block statement is written with output variables, it appears to
be required to include a SUSPEND call so that it will actually return the
output values. I am told the same applies with stored procedures as well. When
such statements are created and they are parsed, if there are output variables
and no call to SUSPEND was detected in the body of the entire statement, the
parser should go ahead and include a final call to SUSPEND as if it had been
written into the body of the execute block or stored procedure. In this way, if
no call to SUSPEND is made and there are output variables, the statement will
function properly when called via ISC_DSQL_EXECUTE2(). As it is now, an
exception is returned that an attempt to read past the end of the cursor was
made. This will allow more flexibility to have clean execute block and stored
procedure statements that are purely for use as singleton statements.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
