Re: DBMS_OUTPUT Hmmm.

In article <MPG.d98b0116f582d95989680_at_nsw-newshost.tpgi.com.au>,   email_at_bisinfo.com.au (Brad Deveson) wrote:
>
> Anyone know why dbms_output wouldn't work in a piece of PL\SQL if an
> exception occurs?
>
> Regards.

Could you be a little more specific? I've done the following...

SET SERVEROUTPUT ON;
DECLARE
 v_dummy VARCHAR2(80);
BEGIN
 SELECT 'X'
   INTO v_dummy
   FROM emp
  WHERE emp_name = 'SOME NON-EXISTANT CRITERIA';  DBMS_OUTPUT.PUT_LINE('Record retrieved');  EXCEPTION
  WHEN NO_DATA_FOUND THEN
   DBMS_OUTPUT.PUT_LINE('No data found...'); END; This works... Unless you're not handling the exception, I don't see why it wouldn't work...

Cheers...

Fernando Luna - Seattle, WA

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet