Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Error
On 18 Oct 2001 05:17:32 -0700, tlmason840_at_aol.com (Tim Mason) wrote:
>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>
>
Remove the ( )
and please check up the create view syntax in the sql reference manual
Hth
>Can someone point me in a direction as to how to fix this error.
>
> Thanks,
> Tim Mason
Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 18 2001 - 13:23:52 CDT