Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> help with D2K
I'm new to Oracle but can someone please tell me why code section #1 works
(does not hit the exception clause), but #2 fails (hits the exception
clause)???
FUNCTION get_prov_name (v_prov# CHAR)
RETURN CHAR IS
v_provname VARCHAR2(29) ;
BEGIN
select RTRIM(firstname) || ' ' || RTRIM(lastname)
into v_provname from health.provider_at_gtw where prov# = 'HSP40113F' ;
EXCEPTION
WHEN OTHERS THEN
RETURN '-1';
END;
FUNCTION get_prov_name (v_prov# CHAR)
RETURN CHAR IS
v_provname VARCHAR2(29) ;
BEGIN
select RTRIM(firstname) || ' ' || RTRIM(lastname)
into v_provname from health.provider_at_gtw where prov# = v_prov# ;
EXCEPTION
WHEN OTHERS THEN
RETURN '-1';
END;
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Jun 29 1998 - 20:03:31 CDT