| 属性/方法 | 描述 |
|---|---|
| BeginTrans() | 开始事务 |
| CommitTrans() | 提交事务 |
| Rollback() | 回滚事务 |
| Close() | 关闭连接 |
| CreateDynaset(...) | 执行查询语句，返回 OraDynaset 对象 |
| CreatePLSQLDynaset(...) | 执行存储过程 |
| ExecuteSQL(sql_statement) | 执行 SQL 语句，返回受影响的行数 |
| Parameters | OraParameters 参数集合对象 |
| CreateDynaset(sql_statement, options, SnapShotID) |
| 参数 | 描述 |
|---|---|
| sql_statement | SQL 查询语句 |
| options | options 参数 |
| SnapShotID | A SnapshotID obtained from the SnapShot property of an OraDynaset. |
| Constant | Value | Description |
|---|---|---|
| ORADYN_DEFAULT | &H0& | 默认设置 |
| ORADYN_NO_AUTOBIND | &H1& | 不执行数据库参数的自动绑定 |
| ORADYN_NO_BLANKSTRIP | &H2& | 从数据库中取字符数据时不去除尾部的空格 |
| ORADYN_READONLY | &H4& | 只读 |
| ORADYN_NOCACHE | &H8& | 不建立本地数据缓存，游标只能往下移动，可以加快速度 |
| ORADYN_ORAMODE | &H10& | Behaves same as Oracle Mode for a database except it affects only the dynaset being created. If database was created in Oracle Mode, dynaset inherits the property from it (for compatibility) |
| ORADYN_NO_REFETCH | &H20& | Behaves same as ORADB_NO_REFETCH mode for a database except this mode affects only the dynaset being created. If the database was created in ORADB_NO_REFETCH mode, the dynaset inherits the property for compatibility. |
| ORADYN_NO_MOVEFIRST | &H40& | 不强制当前记录是开头，BOF 和 EOF = TRUE |
| ORADYN_DIRTY_WRITE | &H80& | Update 和 Delete 不进行一致性检查 |
| CreatePLSQLDynaset( SQLStatement, CursorName , options) |
| --示例:set OraDynaset = objDatabase.CreatePLSQLDynaset("Begin PKG_OT001.PROC003(:PI_UID,:PO_RC);end;","PO_RC",0) |
| 参数 | 描述 |
|---|---|
| sql_statement | 存储过程或语句块 |
| CursorName | 光标名(返回记录集的参数) |
| options | 参数 |
| Constant | Value | Description |
|---|---|---|
| ORADYN_DEFAULT | &H0& | 默认设置 |
| ORADYN_NO_BLANKSTRIP | &H2& | 从数据库中取字符数据时不去除尾部的空格 |
| ORADYN_NOCACHE | &H8& | 不建立本地数据缓存，游标只能往下移动，可以加快速度 |
| ORADYN_NO_MOVEFIRST | &H40& | 不强制当前记录是开头，BOF 和 EOF = TRUE |
| 属性/方法 | 描述 |
|---|---|
| Add(...) | 添加参数 |
| Count | 参数计数值 |
| Remove(member_name) | 删除参数 |
| Add(Name, Value, IOType, ServerType, ObjectName) |
| 参数 | 描述 |
|---|---|
| Name | 参数名 |
| Value | 参数值 |
| IOType | 输入/输出 |
| ServerType | Oracle 内部类型,可选 当为 BLOB, CLOB, BFILE, OBJECT, REF, NESTED TABLE, VARRAY 时必选 |
| ObjectName | 对象名,可选 当为 ORATYPE_OBJECT, ORATYPE_VARRAY, ORATYPE_TABLE 时必选 |
| Settings | Values | Description |
|---|---|---|
| ORAPARM_INPUT | 1 | 输入参数 |
| ORAPARM_OUTPUT | 2 | 输出参数 |
| ORAPARM_BOTH | 3 | 输入/输出参数 |
| Constant | Value | Internal DataType |
|---|---|---|
| ORATYPE_VARCHAR2 | 1 | VARCHAR2 |
| ORATYPE_NUMBER | 2 | NUMBER |
| ORATYPE_SINT | 3 | SIGNED INTEGER |
| ORATYPE_FLOAT | 4 | FLOAT |
| ORATYPE_STRING | 5 | Null Terminated STRING |
| ORATYPE_LONG | 8 | LONG |
| ORATYPE_VARCHAR | 9 | VARCHAR |
| ORATYPE_DATE | 12 | DATE |
| ORATYPE_RAW | 23 | RAW |
| ORATYPE_LONGRAW | 24 | LONG RAW |
| ORATYPE_UINT | 68 | UNSIGNED INTEGER |
| ORATYPE_CHAR | 96 | CHAR |
| ORATYPE_CHARZ | 97 | Null Terminated CHAR |
| ORATYPE_BFLOAT | 100 | BINARY_FLOAT |
| ORATYPE_BDOUBLE | 101 | BINARY_DOUBLE |
| ORATYPE_CURSOR | 102 | PLSQL CURSOR |
| ORATYPE_MLSLABEL | 105 | MLSLABEL |
| ORATYPE_OBJECT | 108 | OBJECT |
| ORATYPE_REF | 110 | REF |
| ORATYPE_CLOB | 112 | CLOB |
| ORATYPE_BLOB | 113 | BLOB |
| ORATYPE_BFILE | 114 | BFILE |
| ORATYPE_TIMESTAMP | 187 | TIMESTAMP |
| ORATYPE_TIMESTAMPTZ | 188 | TIMESTAMP WITH TIMEZONE |
| ORATYPE_INTERVALYM | 189 | INTERVAL YEAR TO MONTH |
| ORATYPE_INTERVALDS | 190 | INTERVAL DAY TO SECOND |
| ORATYPE_TIMESTAMPLTZ | 232 | TIMESTAMP WITH LOCAL TIME ZONE |
| ORATYPE_VARRAY | 247 | VARRAY |
| ORATYPE_TABLE | 248 | NESTED TABLE |
| ORATYPE_RAW_BIN | 2000 | RAW |