c# - 调用存储过程时参数错误的数量或类型错误

Question

下面的代码将文本框中输入的值以列表的形式发送到oracle数据库

而这个列表调用oracle程序。

我想将从这个列表返回的值发送到gridview中。

   public void gridDoldur()
            {

                var seciliProsedur = "Z_LABEL_PRINTER.LabelPieceList";

                List<string> gridList = OraclePieceList();
 using (OracleConnection con = new OracleConnection(connectionString))
            {
                OracleCommand cmd = new OracleCommand(seciliProsedur, con);
                con.Open();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("p_piece_id", OracleDbType.Varchar2).Value = gridList;
                cmd.Parameters.Add("p_rc",OracleDbType.RefCursor).DirectionParameterDirection.Output;
                OracleDataAdapter da = new OracleDataAdapter(cmd);
                OracleCommandBuilder commandBuilder = new OracleCommandBuilder(da);
                DataTable dt = new DataTable();
                da.Fill(dt);
                this.gridPieceList.Visible = true;
                gridPieceList.DataSource = dt;
            }
            conn.Close();

        }

        public List<string> OraclePieceList()
        {

            List<string> pieces = new List<string>();
            for (int i = 0; i < txtListe.Lines.Count(); i++)
            {
                pieces.Add(txtListe.Lines[i]);
            }

            return pieces;
        }

Oracle 程序：声明

 CREATE OR REPLACE PACKAGE Z_LABEL_PRINTER
AS
TYPE t_piece_id IS TABLE OF piece.PIECE_ID %type index by pls_integer; 
PROCEDURE LabelPieceList (p_piece_id IN t_piece_id,
p_rc IN OUT sys_refcursor);
END Z_LABEL_PRINTER;

身体 ：

CREATE OR REPLACE PACKAGE BODY .Z_LABEL_PRINTER
AS
PROCEDURE LabelPieceList(p_piece_id IN t_piece_id,
p_rc IN OUT sys_refcursor)

as
BEGIN
    OPEN p_rc FOR
    SELECT * FROM piece WHERE PIECE_ID IN (SELECT * FROM TABLE(p_piece_id));
    END;
-- Package body
END Z_LABEL_PRINTER;

但我遇到了这个错误：

ORA-06550：第 1 行，第 7 列：PLS-00306：调用“LabelPieceList”时参数的数量或类型错误

标签： c#oracle