Re: How to fix this error

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 10 Oct 2004 06:47:32 +0200
Message-ID: <4168bebf$0$26811$626a14ce@news.free.fr>

"Rich Sias" <zbikie_at_gmail.com> a écrit dans le message de news:d98bdb57.0410091801.25341f7f_at_posting.google.com...
> 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

Maybe this is something like:

merge into aim m1
using flataim m2 on (m2.sn = m1.snam)
when matched then update set m1.snam = m2.sn,

    m1.fnam = m2.fn, m1.lnam = m2.ln, m1.midnam = m2.mn,
    m1.maidn = m2.md, m1.cntry = m2.na, m1.st = m2.st,
    m1.city = m2.cy, m1.empt = m2.mt, m1.nick = m2.nk,
    m1.zip = m2.zp, m1.street = m2.rd

when not matched then insert (M1.ID??,

    m1.fnam, m1.lnam, m1.midnam,
    m1.maidn, m1.cntry, m1.state, m1.city, m1.nick,
    m1.zip, m1.street, m1.snam, m1.empt)

values (AIMSQ.NEXTVAL, m1.fn, m2.ln, m2.mn, m2.md, m2.na, m2.st, m2.cy

    m2.nk, m2.zp, m2.rd, m2.sn, m2.mt);

Regards
Michel Cadot Received on Sat Oct 09 2004 - 23:47:32 CDT