NaN value on database
32691Jan 21 2005 — edited Jan 21 2005Hi all!
I'd like to know what kind of data Oracle database stores when I insert a NaN value. For example:
...
Row myRow = viewObject.createRow();
myRow.setAttribute("NumberField1", new oracle.jbo.domain.Number(Double.NaN));
vo.insertRow();
viewObject.insertRow(myRow);
appModule.getDBTransaction.postChanges();
appModule.getDBTransaction.commit();
...
It's a kind of problematic situation, because any PL/SQL operation on field, like division or multiplication, will generate a loss of service.
Thanks
Gleber