Re: Help with D2K

there is no value for v_prov# in second example

yonglove_at_usa.net wrote:

> 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 - 06:14:21 CEST