Help with D2K

From: <yonglove_at_usa.net>
Date: Tue, 30 Jun 1998 01:02:28 GMT
Message-ID: <6n9df4$mtu$1_at_nnrp1.dejanews.com>

[Quoted] 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)???

• code section #1 ---

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' ;

   RETURN v_provname ;

EXCEPTION
   WHEN OTHERS THEN
      RETURN '-1'; END;

• code section #2 ---

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# ;

   RETURN v_provname ;

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 Tue Jun 30 1998 - 03:02:28 CEST