Re: Create Trigger Error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 May 2001 00:16:24 +0200
Message-ID: <9e1ifn$lf3r$1@ID-62141.news.dfncis.de>

"Julius Siojo" <siojo_at_ejward.com> wrote in message news:3b0445ea$0$2605$39cecf19_at_news2.twtelecom.net...
> How are you all doing? I'm an Oracle newbie. I recently used the
Migration
> Workbench from Oracle and converted from SQLServer to Oracle 8i Personal
> Edition. It was able to migrate the tables and data but had trigger
errors.
> It prevents you from editing the data in the tables where these errors
> occurred. Here is an example log entry:
>
> Type: Error
> Time: 10-05-2001 11:19:07
> Action: Creating
> Message: Failed to create trigger: MAINTENANCE_BAYS_ITRIG: Line 19
> Column 2 - PL/SQL: SQL Statement ignored
> Line 23 Column 19 - PLS-00201: identifier "BAY_NUMBER" must be
> declared
> Line 52 Column 3 - PL/SQL: SQL Statement ignored
> Line 56 Column 20 - PLS-00201: identifier "REUSE_TIMOUT" must be
> declared
>
> What does "must be declared" mean, if these columns exist? How do I
resolve
> this error? Is there a way to view the create trigger statement that
these
> errors originated from? Thanks a lot in advance for you help.
>
> Julius Siojo
>
>
>
>

Must be declared means you don't have the necessary privilege to access them.
Grant the necessary privileges.
Your post really provides insufficient detail to fully resolve this.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 17 2001 - 17:16:24 CDT