SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"number overflow" error in SQL in sqlplus, jdbc, but NOT in sqldev???

XenofonDec 14 2010 — edited Dec 15 2010

Hi there,

I have a very very complex query. You know, one of the kind, you should have rejected in the first time, but you would be forced to implement anyway...

So this query - it doesn't help to paste it here - throws an "ORA-01426 number overflow" error message, where according to my opinion, where it should not, of course...

What drives me nuts is, that the number appears in Java-application (jdbc), in SQLPLUS (oci), but in SQL-Developer (???!!!) it does not! How come?

Anybody any idea?

Is it some jdbc special configurations?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2011

Added on Dec 14 2010

#sql-developer

7 comments

146 views