Post the code ( with
Code:
 my code
tags ) for the nasty procedure and the mviews. You are going to find another error message in the error stack. What does that say? Have you traced a session running the procedure?