type for universal numeric bind variable

[Andrey Maximenko. Ukraine]

CREATE GLOBAL TEMPORARY TABLE TEMP_GRID_REPORT
( ROWN     NUMBER,
  FNAME    VARCHAR2(50 BYTE),
  FNUMBER  NUMBER,
  FSTRING  VARCHAR2(2000 BYTE),
  FDATE    DATE
)ON COMMIT PRESERVE ROWS

I want to save at this table in field data of any numeric type - ftWord, ftFloat, ftCurrency, etc.(from Delphi dataset).

insert into TEMP_GRID_REPORT (FNUMBER) values (:p_FNUMBER)

But bind variable type otNumber - Internal Oracle Datatypes and I can't use this type.
What type of bind variable would be better to use for _FNUMBER ?

 

[Marco Kalter]

You can use any bind variable type that is compatible with number. In order of precision:

- otInteger
- otFloat
- otString