Re: function's clouser - problem
From: <casey.kirkpatrick_at_gmail.com>
Date: 21 Apr 2005 14:46:09 -0700
Message-ID: <1114119969.673786.19580_at_g14g2000cwa.googlegroups.com>
Date: 21 Apr 2005 14:46:09 -0700
Message-ID: <1114119969.673786.19580_at_g14g2000cwa.googlegroups.com>
clouser = closure?
Simple:
CREATE OR REPLACE FUNCTION GET_CL(X IN VARCHAR2) RETURN VARCHAR2 IS
BEGIN
IF X = CL(X) THEN
RETURN X;
ELSE
RETURN(GET_CL(CL(X));
END IF;
END GET_CL;
(NOTE: VARCHAR2 above should be replaced with whatever type X is, and
CL(X) must also have this type... but we knew that, right?)
Received on Thu Apr 21 2005 - 23:46:09 CEST