Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

varchar2(1 byte) column size not accepting a value of 3

818007Nov 23 2010 — edited Nov 24 2010

I am new or oracle and have inherited an application. I noticed that we have a column defined as:

VARCHAR2 (1 byte).

The font-end input web form is trying to insert a value of "3" and insert statement fails.

What is the best way to modify this column. It appears that this column was added recently and can have some rating type of value typically 1 thru 5.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2010

Added on Nov 23 2010

#general-database-discussions

6 comments

6,152 views