Re: creating stored procedure

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 07 Feb 2001 19:27:09 GMT
Message-ID: <95s7hu$v5d$1_at_nnrp1.deja.com>


[Quoted] I don't think you really need a stored procedure. May be sqlplus script [Quoted] will work for you. In that script you can easily use truncate. It's [Quoted] [Quoted] also easier to run sqlplus script from cron. [Quoted] One more suggestion. Even if you decide to use stored procedure, use insert into <temp table>
as select ....
[Quoted] statements. It'll save you time.

[Quoted] 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
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 20:27:09 CET

Original text of this message