Re: Delete in a Stored Procedure?

From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: Mon, 17 Jan 2000 10:18:37 -0000
Message-ID: <948104493.213609@red.parallax.co.uk>

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. Received on Mon Jan 17 2000 - 04:18:37 CST

This message: [ Message body ]
Next message: Pierre Charpenay: "Re: INSERT nextval and UNION SELECT result?"
Previous message: David Thomas: "WebDB - newbie question"
In reply to: Ben Heuer: "Delete in a Stored Procedure?"
Next in thread: toni: "Re: Delete in a Stored Procedure?"
Reply: toni: "Re: Delete in a Stored Procedure?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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