Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> varchar2 length and writing too much
Simple question here, I think.
Oracle 7.3
I created a table with columns of varchar2, one which is defined as varchar2(256).
Recently when I accessed the table using jdbc I got an error: "BIGGER TYPE LENGTH THAN MAXIMUM". When I persued this I found that there were actually 258 characters of description in the column for the row read. I perused this using both Oracle SQL 3.3 and Microsoft Explorer.
I was able to both fix this and "unfix" this by writing new data using Microsoft query.
I am assuming that MS Query is using ODBC. So here are the facts as I see them:
Can someone tell me
1) why Oracle is letting you do this without throwing some type of
error
2) I am assuming Oracle SQL 3.3 would have let me write too much data
also.
3) Is the best way to protect against this is at the application
level?
any comments and responses are appreciated.
Thanks
Jeff
Received on Tue Jan 12 1999 - 11:37:54 CST
![]() |
![]() |