When executing the query SELECT :value FROM dual;
with :value as NUMBER
12345678901234567890
I get the error
'12345678901234567890' is not a valid integer value
While this is correct, it should still be a valid NUMBER
, right?
I can use the workaround: SELECT TO_NUMBER( :value ) FROM dual
.