玉祥平台客服-15087858732

标题: 调用存储过程时的参数类型 [打印本页]

作者: 张军勇 时间: 2020-2-28 09:17
标题: 调用存储过程时的参数类型
调用存储过程中，我们会根据数据类别指定传入的参数类别，在向导中，有几种参数类别:数字（13）,日期(6),字符(22),游标(5)
实际上，存储过程或者说数据类型的参数，每一个驱动提供的数据类型是不同的，以上几种类别的数字，只是针对微软for Oracle驱动时的参数类型。
如果采用其它驱动。这就要根据.net的类型定义来一一对应了：
当使用sql server或sql server9驱动时，在平台中定义为"SqlServer"或“Sqlserver9”
      BigInt = 0,
      Binary = 1,
      Bit = 2,
      Char = 3,
      DateTime = 4,
      Decimal = 5,
      Float = 6,
      Image = 7,
      Int = 8,
      Money = 9,
      NChar = 10,
      NText = 11,
      NVarChar = 12,
      Real = 13,
      UniqueIdentifier = 14,
      SmallDateTime = 15,
      SmallInt = 16,
      SmallMoney = 17,
      Text = 18,
      Timestamp = 19,
      TinyInt = 20,
      VarBinary = 21,
      VarChar = 22,
      Variant = 23,
      Xml = 25,
      Udt = 29,
      Structured = 30,
      Date = 31,
      Time = 32,
      DateTime2 = 33,
      DateTimeOffset = 34,

当使用Oracle驱动时，即微软For Oracle驱动，在平台中定义为"Oracle"
      BFile = 1,
      Blob = 2,
      Char = 3,
      Clob = 4,
      Cursor = 5,
      DateTime = 6,
      IntervalDayToSecond = 7,
      IntervalYearToMonth = 8,
      LongRaw = 9,
      LongVarChar = 10,
      NChar = 11,
      NClob = 12,
      Number = 13,
      NVarChar = 14,
      Raw = 15,
      RowId = 16,
      Timestamp = 18,
      TimestampLocal = 19,
      TimestampWithTZ = 20,
      VarChar = 22,
      Byte = 23,
      UInt16 = 24,
      UInt32 = 25,
      SByte = 26,
      Int16 = 27,
      Int32 = 28,
      Float = 29,
      Double = 30,

当使用Oracle For .net驱动时，即Oracle为.Net做的驱动，在平台中定义为“Oracle11g”
      BFile = 101,
      Blob = 102,
      Byte = 103,
      Char = 104,
      Clob = 105,
      Date = 106,
      Decimal = 107,
      Double = 108,
      Long = 109,
      LongRaw = 110,
      Int16 = 111,
      Int32 = 112,
      Int64 = 113,
      IntervalDS = 114,
      IntervalYM = 115,
      NClob = 116,
      NChar = 117,
      NVarchar2 = 119,
      Raw = 120,
      RefCursor = 121,
      Single = 122,
      TimeStamp = 123,
      TimeStampLTZ = 124,
      TimeStampTZ = 125,
      Varchar2 = 126,
      XmlType = 127,
      Array = 128,
      Object = 129,
      Ref = 130,
      BinaryDouble = 132,
      BinaryFloat = 133,

作者: 万望 时间: 2020-2-28 18:12
这个绝对是干货

又前进了一步

欢迎光临玉祥平台客服-15087858732 (http://bbs.delit.cn/)