Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET Core BLOB/CLOB read error

user7666335Aug 15 2018 — edited Aug 19 2018

Hello.

ODP.NET Core is already in prelease, but still not supports elementary read blob/clob fields.

This simple code  falls with "TTC Errror":

using (OracleConnection conn = new OracleConnection("Data Source=db;User ID=userid;Password=pass;Pooling=False;"))
{
  conn
.Open();
  var sql
= "SELECT id, blobdata FROM templ";
  OracleCommand cmd
= new OracleCommand(sql, conn);
  cmd
.CommandType = CommandType.Text;
  OracleDataReader reader
= cmd.ExecuteReader();
  
using (reader)
  
{
  
while (reader.Read()) //TTC Error
  
{
  
}
  
}

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 16 2018
Added on Aug 15 2018
5 comments
3,352 views