Hello,
    I am unable to insert BLOB objects into Oracle 9i database from .NET. I
get the following exception:

"ORA-01460: unimplemented or unreasonable conversion requested".

I have a table in the database that accepts a number and blob object.
The blob object i am trying to insert is a compressed dataset.

Every thing seems to work fine if i insert small amount of data (compressing
around 500 records) but i get an exception
if i try to store data that has more than 500 records compressed.



Any ideas as to why this may happen?

Thanks

Bala

Hi Bala,

You can try to check if the type of the insert parameters are set properly.
Also, are the size of them correct? If they are correct, could  you please
post the code and SQL stataments that update database here?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Hi Kevin,

I am also having the same problem of inserting > than 32KB of data.This is
the sample code i am posting:

Command Cmd = new Orchestra.DataAccess.Command();
FileInfo fi=new
FileInfo(@"C:\MyData\Old_Gautam_data\BLR-WS-119\songs\telugu\movies\letsc.txt");
StreamReader sr=new StreamReader(fi.FullName);
string tempbuff=sr.ReadToEnd();
MessageBox.Show(sr.BaseStream.Length.ToString(),"length");
Cmd.CommandString="procT";
Cmd.CommandType=CommandType.StoredProcedure; Cmd.AddParameter("inxml",tempbuff,ParameterDirection.Input,OracleType.Clob,(int)sr.BaseStream.Length);
sr.Close();
Cmd .ExecuteNonQuery(-1,Cmd);

Thanks
GautamKumar








Show quoteHide quote

i also have the same problem this is the sample code::

Command Cmd = new Orchestra.DataAccess.Command();

            FileInfo fi=new
FileInfo(@"C:\MyData\Old_Gautam_data\BLR-WS-119\songs\telugu\movies\letsc.txt");
            StreamReader sr=new StreamReader(fi.FullName);
            string tempbuff=sr.ReadToEnd();
            MessageBox.Show(sr.BaseStream.Length.ToString(),"length");
            Cmd.CommandString="procT";
            Cmd.CommandType=CommandType.StoredProcedure;             Cmd.AddParameter("inxml",tempbuff,ParameterDirection.Input,OracleType.Clob,(int)sr.BaseStream.Length);
            sr.Close();
            Cmd .ExecuteNonQuery(-1,Cmd);


Thanks
Gautam

Show quoteHide quote

AD.NET 2.0: BindingSource and Parent Child relationship
DataColumn.Exression and string formatting
How do I assign a typed DataTable to its typed DataSet?
Datagrid calculated column not updating
Manipulating data on input w/ TableAdapter & Dataset.