pass a parameter - Array of Bolbs - to Procedure [message #521302] |
Sun, 28 August 2011 11:15 |
|
yoniarviv
Messages: 1 Registered: August 2011
|
Junior Member |
|
|
hi,
i'm tring to pass to a procedure in oracle an array of blob and i get the error : ORA-03113: end-of-file on communication channel
my code:
using System;
using System.Data;
using Oracle.DataAccess.Client;
public class simplenumberarray
{
public static void Main()
{
using (OracleConnection con = new OracleConnection("data source=orcl;user id=scott;password=tiger;"))
{
con.Open();
using (OracleCommand cmd = new OracleCommand("mypack8.total_the_array", con))
{
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter param1 = new OracleParameter();
param1.ParamName = "p_return_list";
param1.OracleDbType = OracleDbType.Blob;
param1.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
param1.Direction = ParameterDirection = Output;
param1.value=null;
param1.Size=3;
cmd.Parametes.Add(param1);
cmd.ExecuteNonQuery();
}
}
}
}
and if i change it to int evreything is fine.
does oracle support a Array of blob as paramter?
if not,
is there other solutions for the problam?
thanks for any help.
yoni.
|
|
|
|