Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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...
Received on Tue Dec 19 2006 - 10:06:55 CST
![]() |
![]() |