Re: select into NULL in PL/SQL
Date: Sat, 21 Jul 2001 21:17:35 GMT
Message-ID: <9hfru9$aen$1_at_news.eunet.yu>
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
>
>
Received on Sat Jul 21 2001 - 23:17:35 CEST