SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when trying to create table with virtual columns

user572241Feb 8 2019 — edited Feb 10 2019

I am getting ORA-12899 when trying to create following table.

CREATE TABLE code_text2

(

text_clob varchar2(4000),

seg_1 VARCHAR2(4000) GENERATED ALWAYS AS (substr(text_clob,1 , 3000)) VIRTUAL,

seg_2 VARCHAR2(4000) GENERATED ALWAYS AS (substr(text_clob,3001, 3000)) VIRTUAL

)

Curiously - the error says "actual 12000 maximum 4000". So where did the 12000 come from ?

Added on Feb 8 2019

12 comments

616 views