Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

My Pl-Sql Program--Need Help

469220Nov 16 2005 — edited Nov 16 2005
hi there,
i have written a plsql program in oracle using the three tables and they are
1.sailors table
2.reservations table
and 3. boats table

my plsql does the following:

A trigger to implement every sailor is a trainee. It should verify, on DELETE, or UPDATE on the Sailors table, that boats.logKeeper is in Sailors.trainee

The trigger compiles but doen’t work. the message i get is: it is a mutating table!!

so any one willing to pass on their suggestions and opinions can please pass it on to me.
thank u
m.a.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2005
Added on Nov 16 2005
2 comments
298 views