oracle - How to read the cursor more than once -


i working on oracle stored procedure , need inputs on below use case.

  1. stored procedure fetch data in cursor after calculations.
  2. the cursor data returned front end.

now have requirement add cursor data in table , send front end.

as per understanding, once open , read cursor store in table, can't send same cursor front end. have fetch data source table again , send front end. impacts performance.

any ideas on achieving without fetching twice?


Comments