Error when displaying BINARY_FLOAT Infinity value in Result tab: "ORA-01722: Invalid Number" (4277715)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error when displaying BINARY_FLOAT Infinity value in Result tab: "ORA-01722: Invalid Number"
Description

SQL Navigator versions 5.5.4 or 6.0 display a BINARY_FLOAT number with a value of Infinity as 1E126 or 0 in the Result tab. The following error message also occurs:
"ORA-01722: Invalid Number"
Resolution

WORKAROUND
None

STATUS
Enhancement request ST 4772 has been submitted to Development for consideration in a future release of SQL Navigator for Oracle.
Defect ID

ST 4772

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title