Re: Can't put SELECT in formula column

Hi

Try:

Select MONTHS_BETWEEN (:BIRTH_DATE, :CURRENT_DATE)

       into ret_var --> did you catch it?
       from dual;

csdi wrote:
>
> Hi there,
> here is my problem, I want to caculate the age of members using the
> MONTHS_BETWEEN PL/SQL formula in a formula column but I can't run ANY
> select statement in the formula column it always gives me a 'Fatal PL/SQL
> error occured.' and the report aborts.
> Here is my code, what am I doing wrong?
>
> function CF_DEPENDANT_AGEFormula return Number is
> ret_var Number(5);
> begin
> ret_var := 'Select MONTHS_BETWEEN (:BIRTH_DATE, :CURRENT_DATE) from
> dual;';
> return ret_var;
> end;
>
> Thanks in advance. Any help even on any Select statement would be great.
>
> Guy :)
Received on Fri Aug 14 1998 - 23:09:29 CEST