When hovering the mouse over a table trigger variable during debugging, Toad hangs.
Steps to replicate:
1.
CREATE TABLE TEST1
(
COL1 NUMBER(18) NOT NULL,
COL2 NUMBER(18)
)
2.
CREATE TABLE TRANSACTIONS
(
COM VARCHAR2(10 BYTE)
)
3.
CREATE OR REPLACE TRIGGER addComment
AFTER INSERT
ON TEST1
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
DECLARE
tmpVar NUMBER;
BEGIN
IF :new.col1 > 3
THEN
INSERT INTO transactions (com)
VALUES ('inserted>3');
ELSE
INSERT INTO transactions (com)
VALUES ('inserted<3');
END IF;
EXCEPTION
WHEN OTHERS
THEN
-- Consider logging the error and then re-raise
RAISE;
END addComment;
/
4
Then load the trigger in the Editor, Add a breakpoint on the first line with 'IF' , run, compile with debug (enter values 10 & 6) and when complete and you mouse over the :new.col1 Toad hangs.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center