Geek asks and answers

What does OracleParameter.Size affect?

When developing an application that uses ODP.NET in DAL, it is very annoying, always setting the property Size OracleParameter. For instance:

getSPTimeCommand.Parameters.Add("pStartTime", OracleDbType.Varchar2, ParameterDirection.Output).size = 200;

Wasn't it so ugly? Thinking of automatically setting the parameter Size OracleParameter, I thought that it affected the performance or memory consumption. What is this influence? What is your installation script Size?

Thanks in advance!

+3
source share
1 answer

From the documentation :

Defines the maximum size in bytes or characters of data transmitted to or from the database. For an associative PL / SQL Bind array, Size determines the maximum number of elements in a PL / SQL associative array.

varchar2, .

0

More articles:


All Articles