Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Baltimore, MD
    Posts
    8

    Question Unanswered: exception that does nothing?

    Hi,
    I want to have an exception do nothing. or rather, I just want my trigger to ignore this problem, terminate the current block, and go on to the next one.

    here is my code:

    Code:
    EXCEPTION
    			 	WHEN NO_DATA_FOUND THEN
        				DBMS_OUTPUT.PUT_LINE ('');  -- do nothing.
    currently, im getting the error below. I think it has to do with the DBMS overflowing

    ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
    ORA-06512: at "SYS.DBMS_OUTPUT", line 35
    ORA-06512: at "SYS.DBMS_OUTPUT", line 198
    ORA-06512: at "SYS.DBMS_OUTPUT", line 139

    thanks.
    Last edited by wilconow; 10-29-03 at 15:09.

  2. #2
    Join Date
    Sep 2003
    Location
    Baltimore, MD
    Posts
    8

    Thumbs up

    never mind, i believe i found out that you could just put 'null' instead of having dbms output, and the block terminates succesfully, without doing anything.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •