Oops, forgot a THEN. ;-)
In article <9mlf8q$od0$2_at_cronkite.cc.uga.edu>, jeff_at_work.com (Jeff) wrote:
>
>Here's a simple conversion to PL/SQL (adjust to your datatypes and needs):
>CREATE OR REPLACE FUNCTION qryGetDirections( JobNum IN VARCHAR2 )
>RETURN VARCHAR2
>AS
>v_directions tblDirections.directions_desc%TYPE;
>BEGIN
> SELECT directions_desc
> INTO v_directions
> FROM tblDirections
> WHERE job = JobNum;
> RETURN v_directions;
>EXCEPTION
> WHEN no_data_found THEN
> RETURN NULL;
>END;
>
>
>HTH
Received on Thu Aug 30 2001 - 08:34:37 CDT
