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
>>   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_PERSON.F_PERS_NAME,
>>       OUT_PERS_FIRSTNAME type of column T_PERSON.F_PERS_FIRSTNAME,
>>       OUT_PG_NAME type of column T_PRODUCT_GROUP.CF_PG_NAME,
>>       OUT_TOTAL type of D_DECIMAL);
>>
>> end
>>
>> Not something terribly complicated. The only inteeresting thing is the 
>> OUT_PG_NAME parameter, which uses "type of column" on a "computed by" table 
>> column.
>>
> The problem happens because its RDB$PROCEDURE_PARAMETERS has
> RDB$NULL_FLAG = 0 where the new body expects it to be NULL.
> 
> I do not investigate why this difference but probably is something that
> must be valid.
> 
> Please create a ticket.
> 
> 
> Adriano
> 



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to