Devart Forums

cmd = "SELECT FILE_CONTENT FROM " + info.pathinfo.TableName + " WHERE ID = " + id";
oCommand = new OracleCommand(cmd, oConnection);
oDtReader = oCommand.ExecuteReader();

if (oDtReader.HasRows)
{
oDtReader.Read();

oLob = oDtReader.GetOracleLob(oDtReader.GetOrdinal("FILE_CONTENT"));

}
oDtReader.Close();

oLob.Close(); <-- error occurs here

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreLab.Data;
using CoreLab.Oracle;

namespace TestProject
{
public partial class Form1 : Form
{
private string tableName = System.Configuration.ConfigurationManager.AppSettings["TableName"];
private string userID = System.Configuration.ConfigurationManager.AppSettings["UserID"];
private string pwd = System.Configuration.ConfigurationManager.AppSettings["Password"];
private string server = System.Configuration.ConfigurationManager.AppSettings["Server"];
private string port = System.Configuration.ConfigurationManager.AppSettings["Port"];
private string Sid = System.Configuration.ConfigurationManager.AppSettings["Sid"];
private string connString = string.Empty;
OracleLob oLob;
OracleDataReader oDtReader;
OracleConnection conn;
OracleCommand command;

public Form1()
{
InitializeComponent();
}

private void btnClick_Click(object sender, EventArgs e)
{
connString = "User Id=" + userID + ";Password=" + pwd + ";Direct=true;Server=" + server + ";port=" + port + ";Sid=" + Sid;
conn = new OracleConnection(connString);
conn.Open();
command = new OracleCommand("SELECT * FROM " + tableName + " WHERE ID = 2094", conn);
oDtReader = command.ExecuteReader();
if (oDtReader.HasRows)
{
oDtReader.Read();
oLob = oDtReader.GetOracleLob(oDtReader.GetOrdinal("FILE_CONTENT"));
oLob.Close(); //<---Exception occurs here
}
oDtReader.Close();
conn.Close();
}
}
}