triggers

[sai124]

hi
I created a trigger, but atlast it displayed "trigger created with compilation errors".what is compilation error?

[amitpatel66]

hi
I created a trigger, but atlast it displayed "trigger created with compilation errors".what is compilation error?

Try below command to check for errors:

SQL> show err;

It will list out all the errors which occured during compilation!!

[sai124]

Try below command to check for errors:

SQL> show err;

It will list out all the errors which occured during compilation!!

but it displayed tigger created successfully with compilation errors.
**************
if any errors it should display.is'nt it?
but why it is telling that it created successfully(wi th compilation errors).

[amitpatel66]

but it displayed tigger created successfully with compilation errors.
**************
if any errors it should display.is'nt it?
but why it is telling that it created successfully(wi th compilation errors).

Sai,

If your code is perfect without any errors then it will just say "trigger created".
Else
oracle will say trigger created with compilation errors.

Are you running your TRIGGER code in SQL PLUS right?

[sai124]

Sai,

If your code is perfect without any errors then it will just say "trigger created".
Else
oracle will say trigger created with compilation errors.

Are you running your TRIGGER code in SQL PLUS right?

no. in this computer there is no oracle software. i tried to install but after installation it is showing error in password .so i uninstalled it. can i ask u that question on triggers?

[amitpatel66]

no. in this computer there is no oracle software. i tried to install but after installation it is showing error in password .so i uninstalled it. can i ask u that question on triggers?

Ya sure go ahead.

DO POST the trigger for my reference that you have implemented and is displaying error!!