user10683509 wrote:Did you get any error messages when you compiled the procedure or the trigger? if so, post the complete error message(s).
Hi i have been trying to create a trigger that calls a procedure
this what i've been trying without luck so far
when user insert new data set the trigger which the trigger calls a procedure
create or replace procedure helloworldYou need an underscore, not a hyphen, in dbms_ouptut.
x := 'hello world';
and this is the triggerIf you want a comment at the end of a line, put 2 hyphens before the comment, like this:
create or replace trigger salary
after insert or update ON authors
helloworld; (this the procedure name)
helloworld; -- (this the procedure name)
CREATE TABLE authors (I'd create the table first, then create the trigger.
id NUMBER PRIMARY KEY,
INSERT INTO authors (id, first_name, last_name)Did you say
VALUES (1, 'Marlene', 'Theriault');
no luck not working the trigger
first? If you didn't, output from dbms_output will not appear.
SET SERVEROUTPUT ON