Re: SQL Default Question (Resent)

Jim,

The problem is my PL/SQL failed at SELECT clause like this

ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line ....

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:XNW6a.240189$tq4.5707_at_sccrnsc01...
> How about
> num2:=nvl(num2,0);
> Jim
> "abc" <abc_at_abc.com.au> wrote in message
> news:b3hcvh$rrm$1_at_mws-stat-syd.cdn.telstra.com.au...
> > Hi All,
> >
> > I have a PL/SQL to do following calculation:
> >
> > Total = NUM1 + NUM2;
> >
> > SELECT a INTO NUM1 FROM T1;
> > SELECT b INTO NUM2 FROM T2;
> >
> > As b has no return row therefore NUM2 is undefined. Total as a result
> is
> > also undefined (PL/SQL crashed with "No defined value ...")
> >
> > Is there any way to return b as ZERO if no row returned ???
> >
> > I have tried
> >
> > SELECT NVL(
> > (SELECT b INTO NUM2 FROM T2), 0) FROM DUAL;
> >
> > But PL/SQL did not allow me to use SELECT ...(SELECT !
> >
> > SELECT NVL(NUM2,0) FROM DUAL doesn't work.
> >
> >
> >
> >
> >
>
>
Received on Tue Feb 25 2003 - 22:06:38 CST