通过varray oracle传递数组字符串 [英] pass array string by varray oracle

问题描述

cmd.Parameters.Add("arr"，OracleDbType.Int32);
cmd.Parameters ["arr"].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
cmd.Parameters ["arr"].Direction = ParameterDirection.InputOutput;
cmd.Parameters ["arr"].Value = x;
cmd.Parameters ["arr"].Size = 3;
cmd.Parameters ["arr"].ArrayBindSize = new Int32 [3];

cmd.Parameters.Add("v"，OracleDbType.Varchar2);
cmd.Parameters ["v"].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
cmd.Parameters ["v"].Direction = ParameterDirection.InputOutput;
cmd.Parameters ["v"].Value = zx;
cmd.Parameters ["v"].Size = 3;

cmd.Parameters ["v"].ArrayBindSize =新字符串[3]; -我在这行中遇到错误错误1无法将类型"string []"隐式转换为"int []"
任何人都可以帮助我plz

cmd.Parameters.Add ("arr", OracleDbType.Int32 );
cmd.Parameters["arr"].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
cmd.Parameters["arr"].Direction = ParameterDirection.InputOutput;
cmd.Parameters["arr"].Value = x;
cmd.Parameters["arr"].Size = 3;
cmd.Parameters["arr"].ArrayBindSize = new Int32[3];

cmd.Parameters.Add("v", OracleDbType.Varchar2 );
cmd.Parameters["v"].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
cmd.Parameters["v"].Direction = ParameterDirection.InputOutput;
cmd.Parameters["v"].Value = zx;
cmd.Parameters["v"].Size = 3;

cmd.Parameters ["v"].ArrayBindSize= new string [3]; -- i have proplem in this line Error 1 Cannot implicitly convert type ''string[]'' to ''int[]''
anyone help me plz

推荐答案

好吧，ArrayBindSize需要Integer数组.

示例示例:

Well, ArrayBindSize takes Integer array.

A sample example:

param.ArrayBindSize = new int[param.Size] { 36, 36, 36, 36 , 36};

这篇关于通过varray oracle传递数组字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！