Re: SQL Function call does not fail on no_data_found ?
Date: Thu, 25 Mar 2010 10:47:25 -0700 (PDT)
On Mar 24, 9:53 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
> How is that true? PLSQL over SQL? When is that ever better?
It was PLSQL all along ...
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