System.Data.OracleClient

Question

0.00/5 (No votes)

See more:

i tried to insert picture in oracle database using System.Data.OracleClient namespace not oracle.dataAccess but it gives me that error

{"Failed to convert parameter value from a OracleBinary to a Byte[]."}

please could any one help me in that

Posted 23-Jun-10 20:51pm

marjavic

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-06-23T21:56:00

Solution 1

marjavic wrote:
Failed to convert parameter value from a OracleBinary to a Byte[]

Error explains it by itself.

Wrong casting is going on in your code. Resolve it.
Further read this: OracleBinary to Byte[] Conversion[^]

Posted 23-Jun-10 21:56pm

Sandeep Mewara

nshimiyimana · Answer 2 · 2010-06-23T22:18:00

//you have to read the picture into a byte[] first:

FileStream fls;

fls = new FileStream("picturepath", FileMode.Open, FileAccess.Read);

byte[] blob = new byte[fls.Length];

fls.Read(blob, 0, System.Convert.ToInt32(fls.Length));

fls.Close();

//insert into the table.
//the datatype for the picture must be "Blob"
string st = "insert into candidates (photo) values(:BlobParameter )";

OracleParameter blobParameter = new OracleParameter();

blobParameter.OracleType = OracleType.Blob;

blobParameter.ParameterName = "BlobParameter";

blobParameter.Value = blob;

OracleCommand cmnd = new OracleCommand(st, c);

cmnd.Parameters.Add(blobParameter);

cmnd.ExecuteNonQuery();

if you still have a problem, send your codes for a little help.

System.Data.OracleClient

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

System.Data.OracleClient

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us