Geek asks and answers

Oracle NUMBER (20) matches C # type?

What is the corresponding C # type for Oracle NUMBER (20)? Oracle version is 8.

Update:

This is an insert request. Then try adding the following parameter:

IDbDataParameter idParameter = cmd.CreateParameter();
idParameter.DbType = DbType.Int64;
idParameter.Value = id;
cmd.Parameters.Add(idParameter);

Oracle gives me an exception: System.Data.Odbc.OdbcException: ERROR [22007] [Microsoft] [ODBC driver for Oracle] [Oracle] ORA-01840: input value is not long enough for the date format

+3
source share
4 answers

the error message is ORA-01840: input value not long enough for date formatnot a data type mapping error. This is the error you get when Oracle crashes TO_DATEin some cases, for example:

SQL> SELECT to_date('0101', 'ddmmyyyy') FROM dual;

ORA-01840: input value not long enough for date format

I would look into your SQL query / PLSQL block for such an error.

0
source

GetInt32() ? GetDecimal().

0

Int16 for values ​​between -32768 and 32767, Int32 for values ​​between -2147483648 and 2147483647 and Int64 for anything more. this

0
source

More articles:


All Articles