Cannot create packaged routines with [VAR]CHAR parameters
---------------------------------------------------------
Key: CORE-4203
URL: http://tracker.firebirdsql.org/browse/CORE-4203
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 1
Reporter: Adriano dos Santos Fernandes
If the connection charset is different from NONE and the package header is
created there, then it's impossible to create the package body.
If the package header is created in the NONE connection charset, then it
becomes possible to create its body in any other connection charset.
In order to reproduce you need to connect with any non-NONE charset. Then:
CREATE PACKAGE TEST1 AS
BEGIN
FUNCTION F1(X CHAR(3)) RETURNS CHAR(6) ;
END
runs fine. Commit. Then:
CREATE PACKAGE BODY TEST1 AS
BEGIN
FUNCTION F1(X CHAR(3)) RETURNS CHAR(6)
AS
BEGIN
RETURN X;
END
END
returns the error:
Unsuccessful metadata update.
CREATE PACKAGE BODY TEST1 failed.
Function F1 has a signature mismatch on package body TEST1
If both parts are done with the NONE connection charset, there's no error.
--
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 the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
