Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-03-01 Thread Jiří Činčura
Sorry, my fault. I retested again now and for some reason I had 3.0.5 dangling running in Windows (surprisingly without an icon in the tray). Using really 3.0.6 snapshot everything is fine. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at ht

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-03-01 Thread Adriano dos Santos Fernandes
On 28/02/2020 17:03, Jiří Činčura wrote: > Hi Adriano, > > Tested with 3.0.6.33260-0_x64 with the same steps I discovered the issue and > it is still happening. > With the backup you sent this code works: recreate package body QRY_STAFF as begin procedure SALES_PER_USER_PRODUCTGROUP (

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-28 Thread Jiří Činčura
Hi Adriano, Tested with 3.0.6.33260-0_x64 with the same steps I discovered the issue and it is still happening. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-18 Thread Adriano dos Santos Fernandes
Created as ticket CORE-6250. Please test in next v3 build. Adriano On 17/02/2020 16:43, Adriano dos Santos Fernandes wrote: > On 17/02/2020 04:39, Jiří Činčura wrote: >> The package itself has only one procedure with this definition: >> CREATE OR ALTER PACKAGE QRY_STAFF AS >> begin >> procedu

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-17 Thread Adriano dos Santos Fernandes
On 17/02/2020 04:39, Jiří Činčura wrote: > The package itself has only one procedure with this definition: > CREATE OR ALTER PACKAGE QRY_STAFF AS > begin > procedure SALES_PER_USER_PRODUCTGROUP ( > IN_FROM D_DATE, > IN_UNTIL D_DATE) > returns ( > OUT_US_NAME type of column T_U

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-17 Thread Jiří Činčura
> Ok, please send it. Sent. To the email you use here. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-17 Thread Adriano dos Santos Fernandes
On 17/02/2020 14:34, Jiří Činčura wrote: > I can only share gbak backup/database with you (privately as it > contains customer data and structures). Ok, please send it. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-17 Thread Jiří Činčura
> Please send a complete test case with the needed metadata of all objects. I can't, because when I build the database from metadata, the problem does not occur. I can only share gbak backup/database with you (privately as it contains customer data and structures). -- Mgr. Jiří Činčura https:/

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-17 Thread Adriano dos Santos Fernandes
On 17/02/2020 04:39, Jiří Činčura wrote: > The package itself has only one procedure with this definition: > CREATE OR ALTER PACKAGE QRY_STAFF AS > begin > procedure SALES_PER_USER_PRODUCTGROUP ( > IN_FROM D_DATE, > IN_UNTIL D_DATE) > returns ( > OUT_US_NAME type of column T_U

Re: [Firebird-devel] Procedure has a signature mismatch on package body

2020-02-16 Thread Jiří Činčura
The package itself has only one procedure with this definition: CREATE OR ALTER PACKAGE QRY_STAFF AS begin procedure SALES_PER_USER_PRODUCTGROUP ( IN_FROM D_DATE, IN_UNTIL D_DATE) returns ( OUT_US_NAME type of column T_USER.F_US_USERNAME, OUT_PERS_NAME type of column T_P

[Firebird-devel] Procedure has a signature mismatch on package body

2020-02-16 Thread Jiří Činčura
Hi, I'm getting the error in %subj%, when I try to recreate package body of an existing package, BUT the package body is taken without any changes from rdb$packages.rdb$package_body_source. How is this possible? If I do "create or alter" on header (again taken from rdb$packages) right before it