when we are trying to insert more data than (4000) into column varchar(4000) and it doesn't throws the below error. it truncates the data and it saves in to the column. Usually it need to throw below Error why it doesn't throws the error??
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column
It doesn't throw error for data more than column length, it truncates and the total value is stored in blob. If you use report definition you will get exposed data i.e truncated data, whereas when you use obj-open you get the complete value of the property. Thanks.