title: How to get the row count via ADBC native SQL?
body: <p>I can do the following query using Open SQL:</p>
  
  <pre><code>select count(*) into lv_count
  from prcd_elements client specified 
  where waerk = 'USD'
  </code></pre>
  
  <p>How do I do the same thing with ABAP Database Connectivity (ADBC) native SQL?</p>
  
  <p>I've tried the following but it gives me an exception... I'm not sure what data type I need for <code>lt_table</code> to hold a count, and class <code>CL_SQL_RESULT_SET</code> (returned by <code>execute_query</code>) seems to require a local table.</p>
  
  <pre><code>data lt_table type standard table of prcd_elements.
  
  data(lo_sql) = new cl_sql_statement( ).
  data(lo_result) = lo_sql-&gt;execute_query(
    |select count(*) from prcd_elements where waerk = 'USD'|
  ).
  lo_result-&gt;set_param_table( REF #( lt_table ) ).
  lo_result-&gt;next_package( ).
  lo_result-&gt;close( ).
  </code></pre>
  
  <p>Thanks!</p>