Re: calling a SP after materialized view refresh

From: uday <uday1067_at_gmail.com>
Date: 19 Dec 2006 08:06:27 -0800
Message-ID: <1166544387.218606.75940@i12g2000cwa.googlegroups.com>

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 Received on Tue Dec 19 2006 - 10:06:27 CST