Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to get the rows processed count after the SQL statement is finished?

April 26, 2017finished processed rows sql

0

10 Posted

How to get the rows processed count after the SQL statement is finished?

1 Answer

0

10 Posted

The direct_exec() function returns a long int value, which, if it is >= 0, it returns the rows processed count of the constant SQL statement.Also, otl_stream::get_rpc() returns a long int value, which is the rows processed count. The rows processed count is defined for INSERT, UPDATE, and DELETE statements. RPC for SELECT statements means rows fetched count. For any other SQL statement, PL/SQL block, or a stored procedure call, the count is always 0.