reset password
Author Message
304449449
Posts: 10
Posted 14:22 Apr 29, 2016 |

Hello Dr Sun

i am getting this very strange error, i dont have any clue what is this error! I wrote a trigger for the exercise-4! apart from insertion everything is working i am able to check the weather the rating is between 1-5 even weather the customer has rented the movie before giving a rating! if everything is fine when an insertion happens i am getting this error! i have attached a screen shot. please help me dr sun

Attachments:
cysun
Posts: 2935
Posted 17:46 Apr 29, 2016 |

This usually happens when you do some update inside a trigger procedure which causes that trigger to be triggered again - in other words, a trigger that triggers itself. This is like a recursive call that never ends, and eventually you run of out stack space, which seems to be what happened here.

304449449
Posts: 10
Posted 23:03 Apr 29, 2016 |

thanks a lot dr sun for the reply.