Re: How to?: Stored Procedure

There's a good web page:

http://ugweb.cs.ualberta.ca/~c391/manual/chapt9.html

or have a look in ORACLE's "PL/SQL language", manual.

It all depends on what you exactly want to do, but you're on the right tracks with what you've already written . . .

Good luck!

• Martyn Cavett Senior ORACLE Analyst LGT Asset Management London, UK. home: cavett_at_globalnet.co.uk work: Martyn.Cavett_at_gtplc.com

These views are my own and not those of my employer. Normal conditions apply.
nb. anonymous return address used - please replace reply address with those given above.

USA Risk Group, Inc. <kmiller_at_usarisk.com> wrote in article <01bc7d6e$9acd6d80$8497e4ce_at_www>...
> Hello,
>
> At this time I have a series of four update queries that I kick off from
> the command scheduler in NT. I'd like to put them in a stored procedure
 or
> package. What syntax do I use to create the procedure package?
>
> Something like this????????
>
> Create or replace procedure EP_PRO
>
> UPDATE INTO ...
> WHERE ...;
>
> UPDATE INTO ...
> WHERE ...;
>
> UPDATE INTO ...
> WHERE ...;
>
> End EP_PRO;
>
>
>
> - Larry Schenavar
> lorenzo_at_gate.net
>
>
  Received on Fri Jun 20 1997 - 00:00:00 CDT