C#: Oracle Data Type Equivalence with OracleDbType
- by Partial
Situation:
I am creating an app in C# that uses Oracle.DataAccess.Client (11g) to do certain operations on a Oracle database with stored procedures. I am aware that there is a certain enum (OracleDbType) that contains the Oracle data types, but I am not sure which one to use for certain types.
Questions:
What is the equivalent Oracle PL/SQL data
type for each enumerated type in the
OracleDbType enumeration?
There are three types of integer
(Int16, Int32, Int64) in the OracleDbType... how to know
which one to use or are they all
suppose to work?