Re: Need Help with Trigger

Gerry Douglas (gdouglas_at_mailhost.wlc.com) wrote:
: Upon hitting enter, no message is displayed and a PL/SQL prompt is returned.
: After that, when I perform an insert, nothing from tab1 is displayed; only
: confirmation message that a row has been inserted. When I perform a select *
: from sys.user_triggers, the table is empty. (If I had successfully created a
: trigger, the trigger info will be stored in this table, right?)
: What did I do wrong?
Well, this is interesting. Here's what I got:

create trigger trig_test
*
ERROR at line 1:

ORA-06550: line 5, column 6:
PLS-00428: an INTO clause is expected in this SELECT statement
ORA-06550: line 5, column 6:

This is Oracle 7.1.3. with PL/SQL 2. I don't know what versions you're using, but you should also have seen something like this. If you figure out what the problem is, let me know.

Jonathan Received on Mon Jan 08 1996 - 00:00:00 CET