I'm using Oracle Apex 24.1.2. I work on app written by someone else. I have the following field in my table Projects2: "BUSINESS_ID" VARCHAR2(64) NOT NULL ENABLE. This field is hidden and not visible on the form. I have created a sequence to populate it automatically when users enters rest of the data in the form:
CREATE SEQUENCE "BUIS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 20210009 CACHE 2 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
However when I try to update rows from the form I get an error:
- ORA-01400: cannot insert NULL into ("SZZTST"."PROJECTS2"."BUSINESS_ID")
I think the problem may be that sequence is a number and the field is varchar2 (which I can't change). How can I convert this field to varchar2?
