Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE "SOME_TABLE" (
    "_id" BINARY_DOUBLE NOT NULL,
    "double" BINARY_DOUBLE,
    PRIMARY KEY ("_id")
);
alter session set nls_numeric_characters = '.,'
DECLARE
    "#value__id" BINARY_DOUBLE;
    "#value_double" BINARY_DOUBLE;
BEGIN
    "#value__id" := TO_BINARY_DOUBLE('0.0');
    "#value_double" := TO_BINARY_DOUBLE('1.2');

    INSERT INTO "SOME_TABLE" ("_id", "double")
	VALUES(
		"#value__id",
		"#value_double"
);
END;
/
1 rows affected

select * from some_table;


_id
double


0
1.2E+000


rollback;
alter session set nls_numeric_characters = ',.'
DECLARE
    "#value__id" BINARY_DOUBLE;
    "#value_double" BINARY_DOUBLE;
BEGIN
    "#value__id" := TO_BINARY_DOUBLE('0.0');
    "#value_double" := TO_BINARY_DOUBLE('1.2');

    INSERT INTO "SOME_TABLE" ("_id", "double")
	VALUES(
		"#value__id",
		"#value_double"
);
END;
/
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 5

DECLARE
    "#value__id" BINARY_DOUBLE;
    "#value_double" BINARY_DOUBLE;
BEGIN
    "#value__id" := TO_BINARY_DOUBLE('0.0', '999.999', 'nls_numeric_characters=''.,''');
    "#value_double" := TO_BINARY_DOUBLE('1.2', '999.999', 'nls_numeric_characters=''.,''');

    INSERT INTO "SOME_TABLE" ("_id", "double")
	VALUES(
		"#value__id",
		"#value_double"
);
END;
/
1 rows affected

select * from some_table;


_id
double


0
1,2E+000