read 'long-raw' data type from oracle

G

Guest

Hello,

How can I read data field from an oracle procedure with 'long-raw' data type
, using oracle client data adapter?
I tried that:
objPic = New clsPersInfoDT
vCParam1 = New OracleClient.OracleParameter
vCParam2 = New OracleClient.OracleParameter

vCParam1.ParameterName = "emp_photo_data"
vCParam2.ParameterName = "p_employee_number"

vCParam1.OracleType = OracleClient.OracleType.LongRaw
vCParam2.OracleType = OracleClient.OracleType.VarChar

vCParam1.Direction = ParameterDirection.Output
vCParam2.Direction = ParameterDirection.Input

vCParam2.Value = strEmpID
OracleParams = New ArrayList
OracleParams.Add(vCParam1)
OracleParams.Add(vCParam2)


but I've received:
Message "ORA-01406: fetched column value was truncated

Please Advice..
note: i'm using 'oracle client', in VS.NET 2003, using VB.NET
Thanks
Sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unsupported Oracle Datatype - Ref Cursor dont work ! 8
Insert CLOB into Oracle using ADO.NET 6
passing Oracle Nulls in ADO.NET 1
passing Oracle Nulls into a parameter 3
ORA-01406: fetched column value was truncated 4
Oracle Client 5
Oracle Data Provider for .NET: Connection request timed out 0
Problem with insert large data into Oracle clob field 0

Top