Skip to Main Content

Oracle Database Express Edition (XE)

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!

Is there a bug on VALIDATE_CONVERSION function?

Loïc Lefèvre-OracleNov 28 2018 — edited Nov 29 2018

Hi I'm using DB 18c XE for some development and I can't figure out how to make the VALIDATE_CONVERSION function run properly with its full syntax:

Testcase:

alter session set NLS_NUMERIC_CHARACTERS = '.,';

drop table my_test purge;

create table my_test (c1 CLOB constraint my_json_constraint CHECK (c1 Is JSON));

--truncate table my_test;

insert into my_test (c1) values ('{"value":"0,00,0"}');

insert into my_test (c1) values ('{"value":"1234.07"}');

commit;

select t.c1.value,

       VALIDATE_CONVERSION(t.c1.value as NUMBER, '9999D99','NLS_NUMERIC_CHARACTERS = ''.,''') as is_valid

from my_test t;

Is there a way to make it work as the current result is an ORA-00939?

Thanks

Loïc

This post has been answered by Sven W. on Nov 28 2018
Jump to Answer
Comments
Post Details
Added on Nov 28 2018
2 comments
667 views