By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,837 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,837 IT Pros & Developers. It's quick & easy.

read 'long-raw' data type from oracle

P: n/a
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

Feb 24 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.