Re: calling a SP after materialized view refresh

uday schreef:
> Hi
> can any one tell me how can i call a Stored procedure after
> materialized view refreshes itself autometically {the next refresh
> attribute is given to next day}
>
>
> regards
> uday
>

Don't understand the question, I'm afraid - one has nothing to do with the other.
Fact you assume it does, makes me doubt whether I understand what you are trying to ask.

 From SQL*Plus:
define output
exec my_proc(input1 => value, input2 => 'string', output)

That is actually a shortcut for:
declare
output variable_type;
begin

   my_proc(input1 => value, input2 => 'string', output); end;
/

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...