In my C# program, I have a piece of code to create an Oracle table. The table has two fields, X and Y, which should be in double in data type. If I set " ... X double, Y double, ...", I receive an error: ORA-00905: missing keyword. However, if I changed the data type as decimal, it code went through. Then, when I insert records into the table dynamically, the saved X & Y values are integer values in the table rather than as double original source. The data type of X/Y in the table is Number. How can this problem be fixed? Thanks in advance.
using (OracleCommand cmd = new OracleCommand( "create table " + tblName +
"( IIT Varchar2(7) NOT NULL, ETime Number, TrainID Number, CarNo Number, " +
" DestinationNo Number, TrkID Varchar2(12), TrackName Varchar2(2), " +
" Others Varchar2(10), X decimal, Y decimal )", connection) )