Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Error
I was trying to implement a trigger
CREATE OR REPLACE TRIGGER answer_view_Trig
AFTER UPDATE ON MON_Answer
begin
CREATE OR REPLACE VIEW Answer_View AS (SELECT A.MQ_ID, A.MQ_Number, A.MQ_Question, A.MP_ID, A.MQ_Type, B.MA_ID, B.MA_Answer, B.ME_ID FROM MON_Question A, MON_Answer B WHERE A.MQ_ID = B.MQ_ID)
and received the following error.
PLS-00103: Encountered the symbol "(" when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise return select update while <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql commit <a single-quoted SQL string>
Can someone point me in a direction as to how to fix this error.
Thanks, Tim MasonReceived on Thu Oct 18 2001 - 07:17:32 CDT
![]() |
![]() |