Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.42.15.2!HSNX.atgi.net!nnrp.atgi.net!not-for-mail From: Jim Poe Newsgroups: comp.databases.oracle.server Subject: Re: PLS-00306 Date: Thu, 4 Apr 2002 11:53:41 -0800 Organization: Fulcrum InteTech, Inc. Lines: 28 Message-ID: References: NNTP-Posting-Host: 66-182-41-118.atgi.net X-Trace: nnrp.atgi.net 1017950021 28144 66.182.41.118 (4 Apr 2002 19:53:41 GMT) X-Complaints-To: abuse@atgi.net NNTP-Posting-Date: Thu, 4 Apr 2002 19:53:41 +0000 (UTC) X-Newsreader: MicroPlanet Gravity v2.60 Xref: easynews comp.databases.oracle.server:142076 X-Received-Date: Thu, 04 Apr 2002 12:51:47 MST (news.easynews.com) In article , jpoe@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.