try
{
cmd = new OracleCommand(strQuery2, oraConn);cmd.CommandType =
dr = cmd.ExecuteReader();
dr.Read();
{
setSchedulerValues(
dr[“strHours”].ToString(),dr[
);
}
}
{
}
finally
{
oraConn.Close();
}
Thanks, TL.
Hello,
I have a column (varchar2) that was 15 bytes and later I changed it to 30 bytes.
When I open the “columns” tab, I see that the size of the column is 30.
BUT, When I’m trying to retrieve data from this table from my application, I get the first 15 chars of the text that stored in that field, and not the complete text.
Seems like I need to refresh the table structure somewhere…
Please any help…
Just in case it will help, there is the code I use to retrieve the data (C#):
String strQuery2 = String.Format(“SELECT * FROM tblSourcesScheduler WHERE strSourceName=’{0}’”, strSrcName);
OracleConnection oraConn = new OracleConnection(strConnString);
oraConn.Open();
CommandType.Text;if (dr.HasRows)dr[“strWeekDays”].ToString(),“strMinutes”].ToString()catch (Exception exp)