自定义类型: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;