INSERT INTO BRANCH VALUES ('B'||''||BRANCH_SEQ.NEXTVAL, 'FROOD STREET', 'PAISLEY', 'G65 3TA', 01418251070);

INSERT INTO STAFF VALUES ('S'||''||STAFF_SEQ.NEXTVAL, 'WULLIE', 'BROWN', 'TECHNICIAN', 20000, 'M', 'B'||''||BRANCH_SEQ.CURRVAL);

Cant get this to work
first insert creates branchno B10

if I replace the insert into staff for seq.currval to B10 it works

However using the BRANCH_SEQ.CURRVAL is gioving constraint error to do with parent key

Help me please