Oracleparameter constructor Learning

Source: Internet
Author: User

Oracleparameter Constructor (string, oracletype, int32, parameterdirection, Boolean, byte, byte, String, datarowversion, object)

[C #]
Public oracleparameter (
String name,
Oracletype,
Int size,
Parameterdirection direction,
Bool isnullable,
Byte precision,
Byte scale,
String srccolumn,
Datarowversion srcversion,
Object Value
);

Parameters:

Name
Parameter Name.
 
Oracletype
One of the oracletype values.
 
Size
The length of the parameter.
 
Direction
One of the system. Data. parameterdirection values.
Member
Member Name Description
The input parameter is an input parameter.
The InputOutput parameter can be both input and output.
The output parameter is an output parameter.
The returnvalue parameter indicates the return values of operations such as stored procedures, built-in functions, or user-defined functions.

Isnullable
If the field value can be null, true is used; otherwise, false is used.
 
Precision
The total number of digits on both sides of the decimal point to parse the value.

Scale
The total number of decimal places to resolve the value.

Srccolumn
The name of the source column.
 
Srcversion
One of the system. Data. datarowversion values.
Member
Member Name Description
The current row contains the current value.
Default is the default version of datarowstate for the current row.
The original row contains its original value.
The proposed row contains the suggested value.

Value
An object, which is the value of oracleparameter.

Example:
[C #]
Public void createoracleparameter ()
{
Oracleparameter myparameter = new oracleparameter ("dname", oracletype. varchar,
11, parameterdirection. Output, true, 0, 0, "dname ",
Datarowversion. Current, "engineering ");
MessageBox. Show (myparameter. tostring ());
}

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.