Re: PLS-00103: Encountered the symbol "" when expecting one of the following

On Thu, 24 Feb 2005 19:41:15 +0100, Paul Brownjohn <Paul-no-spam-_at_brownjohn.co.uk> wrote:

>TRIGGER TEST.AUDITTRIGGER_AD_ELEMENTS
>On line: 1
>PLS-00103: Encountered the symbol "" when expecting one of the
>following: begin function package pragma procedure subtype type use
> <an identifier> <a double-quoted delimited-identifier> form
>
>However, if I copy the code that has been created and run it in a SQL+
>worksheet, it runs OK and produces a valid usable trigger.
>
>Here is the trigger code that is produced by the script foloowed by the
>the script code itself.
>
>I have now spent 2 days trying to track this one down and desperation is
>setting in!

IIRC the keyword DECLARE is redundant in trigger bodies, as it is in procedure bodies.

--
Sybrand Bakker, Senior Oracle DBA