Re: package won't compile

A copy of this was sent to billmitchell_at_my-deja.com (if that email address didn't require changing) On Wed, 27 Oct 1999 15:02:35 GMT, you wrote:

>I can't seem to get this package body to compile as valid. Can anyone
>point me in the right direction. I'm using the schema manager window
>to test and recompile (8.0.5). I've noticed its a bit sensitive to
>spaces and deletes when recompiling.
>Is there something wrong with this code? Is there a better editor to
>enter procedures/packages?
>
>Thanks in advance.
>(code below)
>
>CREATE OR REPLACE PACKAGE BODY packTest
>AS
>
>procedure allperson
> (id out tid,
> fname out tfname,
> lname out tlname)
>IS
> CURSOR person_cur IS
> SELECT id, fname, lname from testPerson;
>
> percount number default 1;
>
>BEGIN
> FOR singleperson in person_cur
> LOOP
> id(percount) := singleperson.id;
> fname(percount) := singleperson.fname;
> lname(percount) := singleperson.lname;
>
> percount := percount + 1;
> END LOOP;
>END;
>END;
>
>

select * from user_errors

to see the errors (we'll need those).

are tid, tfname, tlname types you defined in the spec? is the spec valid?

>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Oct 27 1999 - 10:23:39 CDT