C#向Oracle存储过程传递数组参数

Question

自定义类型：create or replace TYPE COL AS VARRAY(100) OF varchar2(100);

存储过程：create or replace
PROCEDURE CreateModelTable
(
tableName VARCHAR2,
colName COL,
colType COL,
sqlflag OUT VARCHAR2
)

C#传参语句：

OracleParameter pColName = new OracleParameter(@"colName", Oracle.DataAccess.Client.OracleDbType.Varchar2);

pColName.Direction = System.Data.ParameterDirection.Input;

pColName.Value = nameStr; // string[]类型

pColName.CollectionType = OracleCollectionType.PLSQLAssociativeArray;

Answer 1

ODP.NET How to pass array of strings to an Oracle Stored procedure?