Hello,
Oracle XE on RHE dedicated server
create table cvDetails(
cd_id number(14) primary key,
cv_id number(14) constraint education_fk references CvProperties(cv_id),
nationality varchar2(230),
objectives varchar2(3900),
name varchar2(230),
fatherName varchar2(230),
motherName varchar2(230),
dob varchar2(230),
gender varchar2(230),
mStatus varchar2(230),
passportNo varchar2(110),
email varchar2(230),
phone varchar2(45),
mobile varchar2(25),
address varchar2(2500),
state varchar2(230),
zipCode varchar2(230),
city varchar2(230),
education clob,
experience clob,
skills clob,
languages varchar2(1400),
hobbies varchar2(3200),
achievements varchar2(3900),
references varchar2(3900)
);
create sequence cvDetails_seq
start with 1 increment by 1;
create or replace trigger cvDetails_trig
before insert on cvDetails
referencing new as new
for each row
begin
select cvDetails_seq.nextval into :new.cd_id from dual;
end;
/
Why I am getting the subject error?
Thanks in anticipation