 Re: calling a SP after materialized view refresh
Frank van Bortel wrote:
> 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...
|