Differences between ODP. NET and system. Data. oracleclient

1. ODP.. Net supports updating the number type. It can dynamically determine the decimal point and convert it to the corresponding one. net type. for example, number (4)-> system. int16, number (10)-> system. int32, number (18,2)-> system. decimal
2. If procedure is executed, ODP. net returns-1. The oracleclient, like sqlclient, returns the number of affected rows.
3. ODP. net requirements: You must set the size for the procedure parameter; otherwise, the parameter cannot be passed.

 

In short, I feel that ODP. Net has some optimizations, but some of the functions of oracleclient are not practical (such as exec SP). Or you should pay attention to a lot.