Toad World® Forums

Column size

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)

OK, seems like the table was refreshed during the night, because today I’m getting all the text from that field.
Please someone tell me what I have to do to save changes / refresh it by my self…

Thank You,
TL.