i write procedure in package and write the sql%rowcount value with dbms_output after 3 insert but sql%rowcount still 0
why rowcount dont work?
thanks
PROCEDURE P_ROL_YETKI_EKLE
(
GKISI_UYGULAMA_ID IN GNL_HRK_KULLANICI.NKISI_UYGULAMA_ID%TYPE ,
ROL_ID IN GNL_SBT_ROL_YETKI.NROL_ID%TYPE,
YETKI_ID OUT GNL_SBT_YETKI.NYETKI_ID%TYPE
)
AS
BEGIN
INSERT INTO GNL_SBT_ROL_YETKI( NYETKI_ID,NROL_ID)
SELECT NYETKI_ID,ROL_ID AS NROL_ID FROM
(SELECT NYETKI_ID,NVAD,NUST_YETKI_ID
FROM GNL_SBT_YETKI
START WITH NYETKI_ID = YETKI_ID
CONNECT BY PRIOR NUST_YETKI_ID = NYETKI_ID)
WHERE NYETKI_ID NOT IN (SELECT NYETKI_ID FROM GNL_SBT_ROL_YETKI WHERE NROL_ID=ROL_ID);
dbms_output.put_line('count:'||sql%rowcount);--write 0 after multiple insert
IF SQL%ROWCOUNT = 0 THEN
RAISE_APPLICATION_ERROR(-20311,'');
END IF;
PCK_GNL_LOG.P_KULLANICI_HAREKET_EKLE(GKISI_UYGULAMA_ID, 17 , 0 ,'GNL_SBT_ROL_YETKI','P_ROL_YETKI_EKLE');
COMMIT;
EXCEPTION WHEN OTHERS THEN
ROLLBACK;
RAISE;
END P_ROL_YETKI_EKLE;