Re: Instead-of trigger spurious message
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 30 Jan 2010 18:41:09 -0800 (PST)
Message-ID: <470569.17405.qm_at_web80607.mail.mud.yahoo.com>
That's true. What I really want to find out is why SQL*Plus thinks I have 1 row created but in fact there's none. I'm sure the feedback is reporting the user-level SQL's result and it doesn't care if they're immediately rejected by the recursive SQL. If I insert into v select rownum from dual connect by level <= 11; it reports "11 rows created." and in fact only 10 are.
Date: Sat, 30 Jan 2010 18:41:09 -0800 (PST)
Message-ID: <470569.17405.qm_at_web80607.mail.mud.yahoo.com>
That's true. What I really want to find out is why SQL*Plus thinks I have 1 row created but in fact there's none. I'm sure the feedback is reporting the user-level SQL's result and it doesn't care if they're immediately rejected by the recursive SQL. If I insert into v select rownum from dual connect by level <= 11; it reports "11 rows created." and in fact only 10 are.
Stephane Faroult provided a solution, by using raise_application_error.
Yong Huang
- On Sat, 1/30/10, Gus Spier <gus.spier_at_gmail.com> wrote:
> The text, "One row created" is
> produced from sql*plus. To turn that off, I believe you
> use the sql*plus command, "SET FEEDBACK OFF".
>
> R,
>
> gus
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 30 2010 - 20:41:09 CST