Oracle forms 5.0 Menu Parameter bug ?
From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Tue, 03 Aug 1999 15:02:19 GMT
Message-ID: <01beddd1$c078d400$a504fa80_at_mndnet>
Hi,
query_parameter('&mo'); -- works fine
if to_number(:mo) not between 1 and 12 then -- this is the problem
it gives me error ORA-6502 , Numeric or Value error.
Date: Tue, 03 Aug 1999 15:02:19 GMT
Message-ID: <01beddd1$c078d400$a504fa80_at_mndnet>
Hi,
I created a default menu parameter &mo.
In my pl/sql code for the menu item, when I use
query_parameter('&mo'); -- works fine
if to_number(:mo) not between 1 and 12 then -- this is the problem
message('Problem'); pause;
end if;
it gives me error ORA-6502 , Numeric or Value error.
This example is similar to the one that I saw in the Oracle help for Query_parameter built-in.
Is this a bug ? I do not want any work arounds.
Thanks.
Suresh Bhat
suresh.bhat_at_mitchell-energy.com
Received on Tue Aug 03 1999 - 17:02:19 CEST