Re: Evaluate arithmetic expression in Forms 5
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:31:05 +0800
Message-ID: <378364A9.663C_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:31:05 +0800
Message-ID: <378364A9.663C_at_yahoo.com>
Matthias Haase wrote:
>
> Hi,
>
> i have an arithmetic expression stored in a varchar2 variable and
> i want to evaluate the result of the expression. Is there an easy
> way like 'select :var from dual' to do so or do i have to use
> Dynamic SQL ?
>
> Tanks a lot.
>
> Ciao
> Matthias
never tried this but how about:
- have package variable defined (say pkg.result)
- forms_ddl('begin pkg.result := '||expression||'; end;');
-- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com "Some days you're the pigeon, and some days you're the statue."Received on Wed Jul 07 1999 - 16:31:05 CEST