Re: Can't put SELECT in formula column

Hmmm, I am not sure what you're refering to by 'formula column'. But in general, you should use select .. into in PL/SQL:

function CF_DEPENDANT_AGEFormula return Number is

    ret_var Number(5);
begin

    select MONTHS_BETWEEN (:BIRTH_DATE, :CURRENT_DATE)     into ret_var
    from dual;
    return ret_var;
end;

Arjan. Received on Fri Aug 14 1998 - 19:00:10 CEST