Forum Stats

  • 3,839,935 Users
  • 2,262,549 Discussions
  • 7,901,101 Comments

Discussions

FRM-40735 when mouse double click trigger raised unhandled exceptiORA-01722

LuKKa
LuKKa Member Posts: 533
edited Feb 13, 2010 11:01AM in Forms
I 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 :-
Tagged:

Answers

This discussion has been closed.