Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: calling a SP after materialized view refresh

Re: calling a SP after materialized view refresh

From: uday <uday1067_at_gmail.com>
Date: 19 Dec 2006 08:06:55 -0800
Message-ID: <1166544415.287336.13910@73g2000cwn.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US