Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql%rowcount dont work

JAVAMAN2Jul 27 2009 — edited Jul 27 2009
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2009
Added on Jul 27 2009
8 comments
692 views