need help with PL/SQL Procedure
From: Sven <sven_horn_at_web.de>
Date: 10 Dec 2003 07:05:13 -0800
Message-ID: <4fbac945.0312100705.1b24037a_at_posting.google.com>
Date: 10 Dec 2003 07:05:13 -0800
Message-ID: <4fbac945.0312100705.1b24037a_at_posting.google.com>
i try to write a PL/SQL procedure for Oracle 9.2
is there a way to retrieve the number of affected rows of an INSERT or
an UPDATE statement?
my statement is like:
insert into BEP_EQUIPMENT_CACHE
i tried different ways with RETURNING INTO... but its not working :(
(select * from BEP_EQUIPMENT_MV WHERE EQUIPMENT not in (SELECT
EQUIPMENT FROM BEP_EQUIPMENT_CACHE));
thank you all - sven
Received on Wed Dec 10 2003 - 16:05:13 CET