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.