FRM-40735 when mouse double click trigger raised unhandled exceptiORA-01722
LuKKaFeb 13 2010 — edited Feb 13 2010I am using Forms 10g.
i am writting a procedure in When mouse double click trigger that will display all the values available for ip address from this procedure.
The procedure is
--------------------------
DECLARE
CURSOR cr
IS
SELECT LEVEL NUM
FROM DUAL
CONNECT BY LEVEL<=(Select max_range from t_ip_address_dtl where category_name=:t_item_cpu.category and block_name =:block_head.block)
MINUS
SELECT TO_NUMBER(SUBSTR(IP_address, 12))
FROM T_item_cpu;
abc number(4);
abc1 number(4):=null;
BEGIN
FOR rec IN cr LOOP
abc1 := abc1 || ',' || rec.num;
END LOOP;
Message('You can use between these nos: '||abc1);
Message('You can use between these nos: '||abc1);
END;
--------------------------
It is showing this error :-