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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Trigger Error, pls help...

Re: Oracle Trigger Error, pls help...

From: Marcus Reichardt <mr_at_diamanda.hh.eunet.de>
Date: Mon, 17 Aug 1998 12:27:26 +0200
Message-ID: <35D8058E.5D5F@diamanda.hh.eunet.de> 





There's still another syntax error here:



> >         exception


> >                 when been_booked then


> >                 (select name into guest_name


> >                 from guest


> >                 where guest_no =


> >                       ( select guest_no


> >                         from booking


> >                         where room_no = :new.room_no and


> >                               hotel_no = :new.hotel_no );





The right parenthesis following "then" is unbalanced and obsolete.



Marcus Reichardt
Received on Mon Aug 17 1998 - 05:27:26 CDT












Original text of this message













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