Re: How to fix this error

Rich Sias wrote:

> I am getting the below error, 0947. What can I do to fix this problem.
>
> SQL> run 1
> 1 merge into aim m1
> 2 using flataim m2 on (m2.sn = m1.snam)
> 3 when matched then update set m1.snam = m2.sn,
> 4 m1.fnam = m2.fn, m1.lnam = m2.ln, m1.midnam = m2.mn,
> 5 m1.maidn = m2.md, m1.cntry = m2.na, m1.st = m2.st,
> 6 m1.city = m2.cy, m1.empt = m2.mt, m1.nick = m2.nk,
> 7 m1.zip = m2.zp, m1.street = m2.rd
> 8 when not matched then insert ((select aimsq.nextval from dual),
> 9 m1.fnam, m1.lnam, m1.midnam,
> 10 m1.maidn, m1.cntry, m1.state, m1.city, m1.nick,
> 11 m1.zip, m1.street, m1.snam, m1.empt)
> 12 values ( m1.fn, m2.ln, m2.mn, m2.md, m2.na, m2.st, m2.cy
> 13* m2.nk, m2.zp, m2.rd, m2.sn, m2.mt);
> when not matched then insert ((select aimsq.nextval from dual),
> *
> ERROR at line 8:
> ORA-00947: not enough values
>
> Rich

Fix your syntax and learn to use a sequence properly in an insert statement.

CREATE TABLE t (
seq_col NUMBER(5));

INSERT INTO t
(seq_col)
VALUES
(aimsq.NEXTVAL);

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)