Dear Team,
Good morning.
I have migrated PB 11.2 to 2022 R3 version in my application. In my application, most of the places use double data types.
But after migration, I am getting the wrong value: 45990715392; the actual value should be 45990713430.
After changing the data type, Longlong got the correct value of 45990713430.
Could you please help and give advice on why I am getting the wrong value and why it is not supported Double datatype in my application.
Thanks in advance.
Regards,
Mari
As I mentioned, my application is used in many places with double datatypes.
I am fetching a contract instance from the database table using a stored procedure.
The stored procedure input parameter is passing two string variables, and the return is declared as a double variable.
Double-return value always gets the contract instance number fetched from the table.
While executing the stored procedure, return values 45990715392 (double), which is wrong; the actual value should be 45990713430.
Example below:
double double_return
declare p_procedure procedure for
pck_test.if_get_contractinstanz( :s_contractnumber,
:s_status ) using isqlca;
execute p_procedure;
IF if_dberror() THEN
if_fatalerror("","")
END IF
fetch p_procedure into :double_return;
close p_procedure;
return double_return
The same way is behaving on other screens as well.