Mentat Technologies Technical Forum

I faced few times some issues by editing Oracle 11g Package body through Dreamcoder 6.0 because some lines were appearing at the wrong position.
After investigation dreamcoder is collecting package content via the following query

Select /*+ CHOOSE */  TEXT from sys.user_Source Where  type = 'PACKAGE BODY' and NAME = 'TEST'

Unfortunatelly there is no order by line clause in the statement and this cause the following mistake (wrong ordering of lines)

Initial Package :

CREATE OR REPLACE PACKAGE BODY  TEST AS

FUNCTION IS_CURRENCY(V VARCHAR2) RETURN VARCHAR2 IS
N NUMBER;
BEGIN
    N:=TO_NUMBER(REPLACE(V,',','X'),'99999999999999999999.99999999999999999999','NLS_NUMERIC_CHARACTERS=.,');
    RETURN('Y');
EXCEPTION
    WHEN OTHERS THEN
        RETURN('N');
END;

END TEST;

When entering editor :


CREATE OR REPLACE PACKAGE BODY  TEST AS



FUNCTION IS_CURRENCY(V VARCHAR2) RETURN VARCHAR2 IS

N NUMBER;

BEGIN

    N:=TO_NUMBER(REPLACE(V,',','X'),'99999999999999999999.99999999999999999999','NLS_NUMERIC_CHARACTERS=.,');

    RETURN('Y');

        RETURN('N');


EXCEPTION

    WHEN OTHERS THEN

END;



END TEST;


Is there any bugfix planned for solving it ?

Thank you in advance for your answers