Does PL/SQL have a RowCount 1

[SLAbel]

Hello,

Using SQL Server, I could get the number of rows effected by a delete statement by using @@RowCount. I have looked through my books but as I am not sure what the value/function would be called, my search has come up empty. Any help you could provide would be nice.

Thanks
scott

 

[sem]

Use sql%rowcount.

 

[SLAbel]

Would I use it like this to return the number of rows deleted? Forgive me, I am not at work now and cant test it.

Procedure MyDelete(strValue IN  VarChar2,
                   intRows  OUT Number)
Is
Begin

    Delete
    From   MyTable
    Where  MyColumn = strValue;

    Select sql%rowcount
    Into   intRows
    From Dual;

End MyDelete;

thanks
scott

 

[SLAbel]

Hello,

Just for all of you who want to kno for sure. I am at work and I have tested it and the above way is not correct. You DO use sql%rowcount BUT you use it like this:

Procedure MyDelete(strValue IN  VarChar2,
                   intRows  OUT Number)
Is
      intRows     Number(11);
Begin

    Delete
    From   MyTable
    Where  MyColumn = strValue;

    intRows := sql%rowcount;

End MyDelete;

Hope that helps some others
scott |-0