Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 03, 2008 at 06:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded