Re: select into NULL in PL/SQL

Perhaps try using nvl to replace the null value with something your code can handle.

• Jason http://www.orafocus.com

Dusan Marjanov wrote:

> I think your cursor returns to you no data, and due to it your variables
> contain nulls. Cursor does not return code such 4013. To explore does cursor
> return data or not you need to check variable named sursor_name%DATAFOUND.
> best regards
> Dusan Marjanov
> macko_at_eunet.yu
 

> "Jeff Wilson" <jwilson2000_at_home.com> wrote in message
> news:CX9_6.253872$p33.5088230_at_news1.sttls1.wa.home.com...
> > 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
> >
> >

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Fri Jun 29 2001 - 06:46:56 CDT