Hi all, I have a database table column defined as varchar2(4000) which gets

phanibabuk over 8 years ago

Hi all,
I have a database table column defined as varchar2(4000) which gets created as varchar2(4000 bytes) internally in the database.

But, there is a differenece between varchar2(4000 bytes) and varchar2(4000 char) and I want my xsd to point to the changed type i.e., varchar2(4000 char).

For this I did this change in db?

Will it happen automatically when I map my xsd column with the column in the db table?

Also, will it have any impact if I make this change for existing cdts with running instances.

Discussion posts and replies are publicly visible

Parents

0 rayudua over 8 years ago

ALTER TABLE TBLNAME
MODIFY(COLNOTES VARCHAR2(4000 CHAR));
and also change XSD with right JPA notation
If you used in type="xsd:string" should also work,

<xsd:appinfo source="appian.jpa">
@Column(columnDefinition="CHAR(4000) NOT NULL")
</xsd:appinfo>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rayudua over 8 years ago

ALTER TABLE TBLNAME
MODIFY(COLNOTES VARCHAR2(4000 CHAR));
and also change XSD with right JPA notation
If you used in type="xsd:string" should also work,

<xsd:appinfo source="appian.jpa">
@Column(columnDefinition="CHAR(4000) NOT NULL")
</xsd:appinfo>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data