Re: How to handle Oracle Stored Procedures with output cursor
A cursor requires that the client iterates through the cursor and processes each result row in turn. Qlikview cannot do that. It expects a recordset. If you need to use a cursor then you'll have to code a piece of software that uses the cursor and stores the result in a file. Then qlikview can read the data from the file. But first ask your client to provide you with a name of a database view or a stored procedure that returns the data you need as a recordset instead of a cursor.
Do you have an example of a Oracle SP like that (returns a recordset) that can be called on QlikView? I want to show it to our client so he can take that one as an example and do something based on that.