Cannot create or alter stored procedure with NUMERIC(15,5) in Dialect 1
database via ExecuteImmediate, but can via DSQL
-----------------------------------------------------------------------------------------------------------------------
Key: CORE-3985
URL: http://tracker.firebirdsql.org/browse/CORE-3985
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2
Environment: I tested on both a Win XP 32 bit and a Win 7 64 bit
(running 32 bit) machine and it failed on both.
Reporter: Jason Wharton
I have a case where I can execute a statement via a normal DSQL just fine, but
it fails when I take the same statement and execute it via the API's execute
immediate facility.
Here is the statement:
CREATE OR ALTER PROCEDURE BAD_NUMERIC
(
BAD_IN NUMERIC(15,5)
)
RETURNS
(
BAD_OUT NUMERIC(15,5)
)
AS
BEGIN
END;
I will also attach a demo app that will enable a quick look. Just select the
method to execute the statement through and click execute and it will either
succeed or an exception will be raised.
--
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
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
