Numeric column issue when converting from Oracle 1.8.x to 10.X precompiler.

Problem:

A column defined as numeric (10,0) and the host variable declared as PIC X(10).  If the value was 500 when selected from the database the host variable contained '       500'.

With the Oracle 10.x pre-compiler the host variable contains '500       ' and this is causing a problem within the application.

Resolution:

Use the Oracle precompiler directive picx=varchar2.