Re: Delete in a Stored Procedure?

From: DI Karl Heinz Hörmann <kh.hoermann_at_penta.at>
Date: Tue, 25 Jan 2000 05:38:55 +0100
Message-ID: <86j933$6ro$1@newsmaster01.magnet.at>

Ben Heuer wrote in <08f6992b.da7240e2_at_usw-ex0103-023.remarq.com>...

>Can I use a stored procedure to DELETE records from a table?

yes -

>I have been trying to write a cursor to do so, but I keep getting
>compilation errors!

normally you don't need a cursor ... a cursor is intended for the set traversation during selects of multiple records ...

>I'd appreciate any help..

try:
delete from table_name where condition;

regards Received on Mon Jan 24 2000 - 22:38:55 CST