Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle forms create_group_from_query : upgrade v10 to v12 : order by does not work anymore

User_ODFGYSep 4 2019

We have upgrades our forms from version 10 to 12c.

In the code we do :

rg_id := create_group_from_query(rg_name,lv_text);

   temp  := populate_group(rg_id);

   populate_list('INVOER.type_adres_cd', rg_id);

   delete_group(rg_id);

lv_text :=

'SELECT   rv_meaning

               ,        rv_low_value

               FROM     cg_ref_codes

               WHERE    rv_domain = ''TYPADR''

               AND      rv_low_value IN (SELECT sub_cd

                                         FROM   tag_code_boom

                                         WHERE  boom_cd = ''ADRES''

                                         AND    hfd_cd = '''||lv_type_hfd_cd||''')

               AND      rv_low_value NOT IN (''WOFF'',''WCORR'',''WBTW'',''RR'')

               ORDER BY rv_meaning';

==> result of this query is a list of value :

Correspendentie adres

OVMB Correspondenten adres

Officieel adres

SVMB Correspondenten adres

Vestigingsadres

If we leave out the 'ORDER BY rv_meaning' the lov is not ordered , with  'ORDER BY rv_meaning' the lov is ordered by values starting with 'O%' are not ordered by the second character.

I also tried ordering by  'ORDER BY UPPER(rv_meaning)' ; this gave the same result.

Is this a bug in forms12c?

Comments

Alex Keh-Oracle
Answer

The public beta is not yet available. If you would like to start using the Oracle EF Core beta now, you can join the private beta by sending an email to dotnet_us (at) oracle.com.

Marked as Answer by user5716448 · Sep 27 2020
user5716448

Thanks for update.

user3128813

Can you send me the private beta version of ODP.NET EF Core please?

Alex Keh-Oracle

Sure. Just email dotnet_us (at) oracle.com.

1 - 4

Post Details