Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS-00306

Re: PLS-00306

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Thu, 4 Apr 2002 11:53:41 -0800
Message-ID: <MPG.17164f1dbab00e90989681@news.callatg.com>


In article <MPG.17162779efa70d73989680_at_news.callatg.com>, jpoe_at_fulcrumit.com says...
>
>
> I am trying to run an anonymous pl/sql block and I keep getting the
> error
> ORA-06550: line 7, column 21:
> PLS-00306: wrong number or types of arguments in call to '='
>
> The block starts out like this:
>
> declare
> 2 cursor contacts is
> 3 select ctac_id from ctac;
> 4 begin
> 5 for vCtacID in contacts loop
> 6 update ctac set ctac_id=party_seq.nextval
> 7 where ctac_id = vCtacId;
>

should be 'where ctac_id = vCtacId.ctac_id' he says slapping hand on forehead.

-- 
Jim Poe
Fulcrum InteTech, Inc.
<jpoe_at_fulcrumit.com>
Received on Thu Apr 04 2002 - 13:53:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US