Calling Oracle Stored Procedure in Load Script Does Not Return Data
I have a stored procedure that returns a ref cursor. I can execute the stored procedure in Toad and it returns results. If I call this from my QlikView load script, I get an error regardless of the syntax I use. I read on one of the posts that you can only return a result set from Oracle functions, not stored procedures, in QlikView.
So, I created a function that calls the stored procedure and returns the Ref Cursor. I can successfully call this from Toad and I get a result set. If I call it from QlikView, it appears to run, but I never get any result. In other words, there are no tables.
Here is the syntax that I'm using...
OLEDB CONNECT TO [my connect string.....](mode is write);