Hi! When I worked with SQL Server, returning the number of rows from a function that performed updates or deletes was frown upon, In fact, we had to disable row count in every function/procedure.
I am wandering what ramifications of returning SQL%ROWCOUNT from Oracle PL\SQL perspective are? Is sql%rowcount known to slow things down? Is it reliable/consistent?
The function is to be used from a distributed web app with connection pooling.
I googled but cannot seem to find any discussions?
Many thanks in advance,