Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create Trigger Error
julius...
maybe those triggers are calling some stored procedures or something similar which have not been imported into ur oracle db...i mean "bay_number" and "reuse_timout" may be stored procedures..
there are system tables in oracle where the code for the triggers and stored procedures can be found....
run this query to get the complete code of the trigger..... given that ur trigger name is MAINTENANCE_BAY_ITRIG
SQL> set long 10000
SQL> select trigger_body from user_triggers where trigger_name =
'MAINTENANCE_BAY_ITRIG' ;
this will give u the code of the trigger....then maybe u could track down
whats going wrong...if it says "something" must be declared...look for a
line in the code that refers to that "something"....should be pretty
straightforward....
all the best
ciao
venkat
"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
>
>
>
>
Received on Mon May 21 2001 - 07:27:51 CDT