Re: SQL Function call does not fail on no_data_found ?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 25 Mar 2010 10:47:25 -0700 (PDT)
Message-ID: <4ce20297-0c95-4330-a9e3-e3261af64565_at_u9g2000yqb.googlegroups.com>
On Mar 24, 9:53 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
Date: Thu, 25 Mar 2010 10:47:25 -0700 (PDT)
Message-ID: <4ce20297-0c95-4330-a9e3-e3261af64565_at_u9g2000yqb.googlegroups.com>
On Mar 24, 9:53 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
snip
> How is that true? PLSQL over SQL? When is that ever better?
It was PLSQL all along ...
BEGIN
SELECT ename INTO l_ename FROM emp WHERE empno = p_empno ;
RETURN l_ename ;
END ;
AFAIK the only way to do SELECT INTO in oracle is in PLSQL.
Received on Thu Mar 25 2010 - 12:47:25 CDT