Toad World® Forums

Bind variables cannot deal with large NUMBERs

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.



Fixed for next beta