Re: Instead-of trigger spurious message

From: Yong Huang <>
Date: Sat, 30 Jan 2010 18:41:09 -0800 (PST)
Message-ID: <>

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 <> 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

Received on Sat Jan 30 2010 - 20:41:09 CST

Original text of this message