Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL SQL variable/scope question
Try changing cr definition to "ct find_rows%rowtype;"
Larry Johnson
KeepItSimpleEngineering,Inc.
"Jay Scheiner" <jayms_at_nospamaol.com> wrote in message
news:3ba27a3e.10208625_at_news.starpower.net...
> I am having trouble figuring out why this isn't working (this is a
> shortened version to clarify my problem)
>
> create procedure misc as
> cursor find_rows .....;
> cr table%rowtype;
> x number(10);
> procedure subr as
> begin
> x := cr.item
> end subr;
> --
> for cr in find_rows loop
> subr;
> end loop;
>
> The problem is that inside the subroutine the cursor row (cr) seems to
> be empty. Do I need to refer to it differently? Pass it as a
> parameter? Declare it as global (how)? Thanks for any help on this.
Received on Sat Sep 15 2001 - 11:18:28 CDT