Re: Delete in a Stored Procedure?

Phil Preen wrote:

> Ben Heuer <queerczarNOquSPAM_at_unforgettable.com.invalid> wrote in message
> news:08f6992b.da7240e2_at_usw-ex0103-023.remarq.com...
> > Hello,
> >
> > Can I use a stored procedure to DELETE records from a table?
> >
>
> create procedure MyProc is
> begin
> delete from MyTable;
> end;
> /
>
> Phil.

create procedure MyProc is
begin
  delete from MyTable;
 commit;
end;
/
;) Received on Mon Jan 17 2000 - 05:18:12 CST