activities
latest
false
- 概要
- 暗号化
- データベース
- Java
- Python
- Web API
重要 :
このコンテンツの一部は機械翻訳によって処理されており、完全な翻訳を保証するものではありません。
開発者向けのアクティビティ
Last updated 2024年9月12日
ベスト プラクティス
When using stored procedures in Oracle, ensure that the REF CURSOR is correctly bound with the
Oracle.ManagedDataAccess.Types.OracleRefCursor
variable.
To do so, you need to make sure the number of parameters and their type match the ones setup in the Parameters property of the Run Query activity.
You can get the content of the cursor using the Invoke Code activity or you can pass it to another database query as an input parameter. Here is a sample invoke code to convert it to a data table:
Oracle.ManagedDataAccess.Client.OracleDataReader reader2 = myRefCursor.GetDataReader();
dt = new DataTable();
dt.Load(reader2);
Oracle.ManagedDataAccess.Client.OracleDataReader reader2 = myRefCursor.GetDataReader();
dt = new DataTable();
dt.Load(reader2);
You should dispose the cursor when you are done with it. You can do it either with Invoke Code activity (
myRefCursor.Dispose
), with Invoke Method activity from the System activity package or via an SQL command that you run.