Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rivard007
Starting Member
2 Posts |
 Posted - 2007-05-28 : 09:39:03
|
| Hello, I am developing in C# and Oracle. I am trying to insert into a table and it keeps giving me an error that the column width is set at 20 characters. The width is however set to 3000 characters. I have things in the table that are way above 20 characters already. The table was imported from excel. Can someone please tell me what I can do? right now its VARCHAR2(3000 char) before I tried VARCHAR@(3000 bytes)thanks, |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-28 : 09:44:13
|
| This site is specifically to post MS-SQL questions. Post ORACLE questions in other forum sites like orafaq.com or dbforums.comHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rivard007
Starting Member
2 Posts |
Posted - 2007-05-28 : 09:45:17
|
| hey i fixed the error... apparently my columns sizes are not being automatically generated properly so it was taking the sizes of other columns. So if anyone has the same problem just change all the columns to a much larger size to easily get around the error. |
|
|
|
|
|
|
error is killing me ORA - 12899