none
alter columns with not null value RRS feed

  • Question

  • hi

    i have 2 columns in my table which would ideally get inserted with the same information, but one is not null.

    i now need to increase the allowed character limit for these columns from 255 to 510 due to an insert error i am seeing in my application.

    error: java.sql.SQLException: ORA-12899: value too large for column

    i need help with constructing a query for the not null column

    alter table pfuser.archivepointentrysync alter column apesname nvarchar(510) not null

    alter table pfuser.archivepointentrysync alter column apesdisplayname nvarchar(510) null

    the second query goes through fine and updates the char limit to 510 successfully.

    however the first query for the not null column is failing.

    error:  the object uk_apes is dependent on column 'apesname'.

    alter table alter column apesname failed because one or more objects access this column.

    i am not too good with these queries, any help is appreciated please.



    • Moved by Shanky_621MVP Monday, October 30, 2017 4:59 PM question related to Oracle
    Monday, October 30, 2017 1:04 PM

All replies