Using Oracle Stored Procedures for report data source...
When using a Oracle stored procedure as your data source for a crystal report (version 9) does it create a cursor? I'm wondering how it works when multiple users are running reports using that stored procedure. Does each user get a view of the data (per user session)? Does that data area that's created by each stored procedure request get released and/or deleted at the completion of the report?
What actually happens in the process of creating a report using a stored procedure? Does it act as a "temporary" table?
Kyle McAdam replied
Each report request to the stored procedure is a unique session. It is not shared with any other users. The connection to the database remains open, until the application is closed, or the connection is explicitly closed by the application. The stored procedure processing is complete when the result is returned.