Using 'long' numbers - NUMFORMAT?

[andyh]

We use 32 digit numbers within our application for surrogate keys, etc.

When displaying these numbers within PSD they are shown in the 'E' format and PSD uses the 'E' format when showing foreign-key pick-lists on the 'edit data' views. If you use the value presented from the pick-list, the value that is attempted to be stored is *not* the correct value.

Similarly, when using DataGenerator to refer to these same numbers.

I *think* that I need the equivalent of NUMFORMAT in SQL*PLUS, but not sure how to achieve this.

Ideas?

 

[Marco Kalter]

For the SQL Window you can use the "Number fields to_char" preference (Tools > Preferences > SQL Window). This way the numbers are fetched as varchar2 values with full precision.

 

[andyh]

Thanks!

That sorts out how the fields are displayed - is there a known workaround for the pick-lists and data generator?

 

[Marco Kalter]

No, I don't have a workaround for these 2 functions.