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

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

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

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