Toad World® Forums

REF CURSOR results displaying numbers in scientific notation

Using Toad for Oracle I have numerous procedures that produce a REF CURSOR as the output. When viewing the results in Toad the numeric fields are displayed in scientific notation and when I cut and paste from there to excel they also appear in scientific notation. In Options for Data Grids—> I have the checkbox unchecked for Display large numbers in Scientific Notation. Is there something else I need to change or can this checkbox be made to also control the REF CURSOR results grid.

There is no work around for this one right now, and unfortunately, it’s not a simple fix.