topic Re: Database in Operating System - HP-UX

Database

Henry Chua — Fri, 27 May 2005 09:15:05 GMT

I tried this sql/pl script
:
CREATE OR REPLACE TRIGGER update_tab2
BEFORE INSERT ON tab1
FOR EACH ROW
begin
UPDATE tab2
SET data=1
WHERE cus_id := new.cus_id;
END;

but I got this error:

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER QOH_INSERT:

LINE/COL ERROR
-------------------------------------------
2/4 PL/SQL: SQL Statement ignored
4/17 PL/SQL: ORA-00920: invalid relational operator

anyone know what i did wrong?

Re: Database

John Wimmer_1 — Fri, 27 May 2005 09:38:02 GMT

WHERE cus_id := new.cus_id;

That line should be an = instead of a :=

Re: Database

Simon Hargrave — Fri, 27 May 2005 09:38:51 GMT

I'm no SQL expert but should there really be a := instead of = in your WHERE clause?

Re: Database

Eric Antunes — Fri, 27 May 2005 10:21:05 GMT

See here:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=888479

:)