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...