Re: select into NULL in PL/SQL

From: crappy <crappygolucky_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:17:03 GMT
Message-ID: <ce31c410.0106270718.66167c37_at_posting.google.com>


oops, i misunderstood the problem. never mind what i said. nvl won't help.

Alex Filonov <afilonov_at_pro-ns.net> wrote in message news:<3B39476A.72E83966_at_pro-ns.net>...
> Jeff Wilson wrote:
>
> > Have looked everywhere for an example or explanation of this without
> > success.
> >
> > Have a table with a column that can contain NULL. Am using a cursor to loop
> > over every record and load this column value into a variable using SELECT
> > INTO.
> >
> > When I get to a NULL value, I get an ORA-04013 or similar that says "data
> > not found". I actually want to treat NULL values in a particular way in the
> > logic, not ignore them. Otherwise, I could just bind the cursor to a query
> > that leaves out the NULLs.
> >
> > I guess it makes sense to not want uninitialized variables floating around
> > your PL/SQL code, but Oracle handles NULL values pretty gracefully
> > elsewhere.
> >
> > Can someone provide either an explanation of why this must work this way or
> > a possible workaround.
> >
> > Many thanks.
> >
> > --
> > Jeff Wilson
> > jwilson2000_at_home.com
> > Eugene, Oregon
> >
> > (541) 684-8590
>
> Could you please post a piece of code? It's kinda strange to use SELECT INTO if
> you hava a cursor already. ORA-1403 No data found has nothing to do with NULL,
> it's trying to tell you that there is no records in the select statement
> output.
Received on Sat Jul 21 2001 - 23:17:03 CEST

Original text of this message