Re: creating stored procedure

Hi Alex

Thanks for the help.
[Quoted] [Quoted] Writing SQL script is more easier. My boss wants me to write a stored [Quoted] [Quoted] procedure. I want to know would the stored procedure run from cron or [Quoted] not. Can I tell him it is better to run SQL script than stored procedure.

[Quoted] Thanks in anticipation.
[Quoted] In article <95s7hu$v5d$1_at_nnrp1.deja.com>, [Quoted]   Alex Filonov <afilonov_at_pro-ns.net> wrote:
> I don't think you really need a stored procedure. May be sqlplus
 script
> will work for you. In that script you can easily use truncate. It's
> also easier to run sqlplus script from cron.
> One more suggestion. Even if you decide to use stored procedure, use
> insert into <temp table>
> as select ....
> statements. It'll save you time.
>
> In article <95p2l8$4ik$1_at_nnrp1.deja.com>,
> kushan <vikasmamta_at_my-deja.com> wrote:
> > Hi
> >
> > I am creating a stored procedure to select the data from 5 tables &
> > then inserting into one table. And I want to run this procedure
 hourly
> > by setting its cronjob. Can you check my syntax
> >
> > Create or replace procedure P1
> > Begin
> >
> > Select ......... from ..... where...=....;
> > Insert into temp table ........;
> > Select ......... from ..... where...=....;
> > Insert into temp table ........;
> > ....like this many selects & inserts......
> > end;
> >
> > Is that necessary to give parameters in or out or would it work.
> >
> > one more thing Everytime when the procedure will run it will get the
> > completedata from different table & insert it into temp table so
 that
> > temp table keep on getting duplicated rows. If I create a primary
 key
> > in the temp table would that help me. Or do I need to use truncate.
 If
> > So where i need to write this truncate in the procedure. Please help
 me
> > out with this problem> I am in real trouble.
> >
> > Thanks
> >
> > --
> > RICHARD
> > [Quoted] [Quoted] [Quoted]
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

--
RICHARD


Sent via Deja.com
http://www.deja.com/