Re: PL/SQL Error

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Thu, 18 Oct 2001 14:57:25 +0200
Message-ID: <9qmjeu$j1v$1@wanadoo.fr>

I have tried to make that and had the same error

PLS-00103: Encountered the symbol "CREATE" 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>

it seems to be impossible create something inside the trigger (when I replace
create statement by something else, this works).

"Tim Mason" <tlmason840_at_aol.com> a écrit dans le message news: 258a1e3f.0110180417.302fa60d_at_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:57:25 CDT