2 // System.Data.OracleClient.OracleParameter
\r
5 // Konstantin Triger <kostat@mainsoft.com>
6 // Boris Kirzner <borisk@mainsoft.com>
8 // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
12 // Permission is hereby granted, free of charge, to any person obtaining
13 // a copy of this software and associated documentation files (the
14 // "Software"), to deal in the Software without restriction, including
15 // without limitation the rights to use, copy, modify, merge, publish,
16 // distribute, sublicense, and/or sell copies of the Software, and to
17 // permit persons to whom the Software is furnished to do so, subject to
18 // the following conditions:
20 // The above copyright notice and this permission notice shall be
21 // included in all copies or substantial portions of the Software.
23 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
24 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
25 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
26 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
27 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
28 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
29 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
36 using System.Data.Common;
\r
37 using System.Data.ProviderBase;
\r
38 using System.Globalization;
\r
43 namespace System.Data.OracleClient {
\r
44 public sealed class OracleParameter : AbstractDbParameter, IDbDataParameter, ICloneable {
\r
48 OracleType _oleDbType = OracleType.VarChar;
\r
50 #endregion // Fields
\r
52 #region Constructors
\r
54 public OracleParameter() {
\r
57 public OracleParameter(String parameterName, Object value)
\r
58 : this (parameterName, OracleType.VarChar, 0, ParameterDirection.Input,
\r
59 false, 0, 0, String.Empty, DataRowVersion.Current, value) {
\r
60 IsDbTypeSet = false;
\r
63 public OracleParameter(String parameterName, OracleType dbType)
\r
64 : this (parameterName, dbType, 0, ParameterDirection.Input,
\r
65 false, 0, 0, String.Empty, DataRowVersion.Current, null) {
\r
68 public OracleParameter(String parameterName, OracleType dbType, int size)
\r
69 : this (parameterName, dbType, size, ParameterDirection.Input,
\r
70 false, 0, 0, String.Empty, DataRowVersion.Current, null) {
\r
73 public OracleParameter(String parameterName, OracleType dbType, int size,
\r
74 String sourceColumn)
\r
75 : this (parameterName, dbType, size, ParameterDirection.Input,
\r
76 false, 0, 0, sourceColumn, DataRowVersion.Current, null) {
\r
80 public OracleParameter(String parameterName,
\r
83 ParameterDirection direction,
\r
87 String sourceColumn,
\r
88 DataRowVersion sourceVersion,
\r
90 ParameterName = parameterName;
\r
91 OracleType = dbType;
\r
93 Direction = direction;
\r
94 IsNullable = isNullable;
\r
95 Precision = precision;
\r
97 SourceColumn = sourceColumn;
\r
98 SourceVersion = sourceVersion;
\r
102 #endregion // Constructors
\r
106 public override DbType DbType {
\r
107 get { return OracleConvert.OracleTypeToDbType(_oleDbType); }
\r
108 set { OracleType = OracleConvert.DbTypeToOracleType(value); }
\r
111 public OracleType OracleType {
\r
112 get { return _oleDbType; }
\r
114 _oleDbType = value;
\r
115 IsDbTypeSet = true;
\r
119 public new Object Value {
\r
120 get { return base.Value; }
\r
122 if (!IsDbTypeSet && (value != null) && (value != DBNull.Value)) {
\r
123 _oleDbType = OracleConvert.ValueTypeToOracleType(value.GetType());
\r
125 base.Value = value;
\r
130 public new byte Precision {
\r
131 get { return base.Precision; }
\r
132 set { base.Precision = value; }
\r
135 public new byte Scale {
\r
136 get { return base.Scale; }
\r
137 set { base.Scale = value; }
\r
141 #endregion // Properties
\r
145 public override String ToString() {
\r
146 return ParameterName;
\r
149 protected override string Placeholder {
\r
151 if (ParameterName.Length == 0 || ParameterName[0] == ':')
\r
152 return ParameterName;
\r
154 return String.Concat(":", ParameterName);
\r
158 internal string InternalPlaceholder {
\r
160 return Placeholder;
\r
164 protected sealed override object ConvertValue(object value) {
\r
165 // can not convert null or DbNull to other types
\r
166 if (value == null || value == DBNull.Value) {
\r
170 // TBD : some other way to do this?
\r
171 // if (OracleType == OracleType.Binary) {
\r
174 // .NET throws an exception to the user.
\r
175 object convertedValue = value;
\r
177 // note : if we set user parameter jdbc type inside prepare interbal, the db type is not set
\r
178 if (value is IConvertible && (IsDbTypeSet || IsJdbcTypeSet)) {
\r
179 OracleType oleDbType = (IsDbTypeSet) ? OracleType : OracleConvert.JdbcTypeToOracleType((int)JdbcType);
\r
180 Type to = OracleConvert.OracleTypeToValueType(oleDbType);
\r
181 if (!(value is DateTime && to == OracleConvert.TypeOfTimespan)) //anyway will go by jdbc type
\r
182 convertedValue = Convert.ChangeType(value,to);
\r
184 return convertedValue;
\r
187 protected sealed override void SetParameterName(ResultSet res) {
\r
188 ParameterName = res.getString("COLUMN_NAME");
\r
191 protected sealed override void SetParameterDbType(ResultSet res) {
\r
192 int jdbcType = res.getInt("DATA_TYPE");
\r
193 // FIXME : is that correct?
\r
194 if (jdbcType == Types.OTHER) {
\r
195 string typeName = res.getString("TYPE_NAME");
\r
196 if (String.Compare("REF CURSOR", typeName, true, CultureInfo.InvariantCulture) == 0) {
\r
197 jdbcType = (int)JavaSqlTypes.CURSOR;
\r
199 else if (String.Compare("BLOB",typeName,true, CultureInfo.InvariantCulture) == 0) {
\r
200 jdbcType = (int)JavaSqlTypes.BLOB;
\r
202 else if (String.Compare("CLOB",typeName,true, CultureInfo.InvariantCulture) == 0) {
\r
203 jdbcType = (int)JavaSqlTypes.CLOB;
\r
205 else if(String.Compare("FLOAT",typeName,true, CultureInfo.InvariantCulture) == 0) {
\r
206 jdbcType = (int)JavaSqlTypes.FLOAT;
\r
208 else if(String.Compare("NVARCHAR2",typeName,true, CultureInfo.InvariantCulture) == 0) {
\r
209 jdbcType = (int)JavaSqlTypes.VARCHAR;
\r
211 else if(String.Compare("NCHAR",typeName,true, CultureInfo.InvariantCulture) == 0) {
\r
212 jdbcType = (int)JavaSqlTypes.VARCHAR;
\r
215 OracleType = OracleConvert.JdbcTypeToOracleType(jdbcType);
\r
216 JdbcType = jdbcType;
\r
219 protected sealed override void SetSpecialFeatures(ResultSet res) {
\r
223 protected sealed override int JdbcTypeFromProviderType() {
\r
224 return OracleConvert.OracleTypeToJdbcType(OracleType);
\r
227 #endregion // Methods
\r