actully i had a scenereo where i need to populate a temp. table just
after the materialized view refreshes it self.

for which the logic was so comples that can-not be expressed in a
single select statement, every tuple has to be calculated then
inserted, i did this by a procedure, now i want to call this just after
the M-View gets refreshed.

though i have other options, like seeting a job scheduler either at the
db server or the app server.

thanks for ur response

uday