Home » Infrastructure » Windows » pass a parameter - Array of Bolbs - to Procedure
pass a parameter - Array of Bolbs - to Procedure [message #521302] Sun, 28 August 2011 11:15 Go to next message
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.




Re: pass a parameter - Array of Bolbs - to Procedure [message #521304 is a reply to message #521302] Sun, 28 August 2011 12:08 Go to previous message
Michel Cadot
Messages: 67839
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel
Previous Topic: Need help
Next Topic: Oracle OLEDB vs Microsoft OLEDB
Goto Forum:
  


Current Time: Fri May 07 05:05:56 CDT 2021