Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Error

PL/SQL Error

From: Tim Mason <tlmason840_at_aol.com>
Date: 18 Oct 2001 05:17:32 -0700
Message-ID: <258a1e3f.0110180417.302fa60d@posting.google.com>


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)

end

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 Mason
Received on Thu Oct 18 2001 - 07:17:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US