Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is anyone able to get a record set from an oracle stored proc with an output type of refcursor ?
If you are, please share.
I have a very simple procedure. It takes two in params of string type and one out param of refcursor type.
The issue seems to be around the bind variable for the output cursor.
I have tried every load statement and argument list combination that I can think of:
LOAD *;
SQL CALL sp_name('string1','string2', what-goes-here ?)
mostly, I get the "wrong number or type of argument" error.
Thanks for any thoughts.
TD
you can call store procedure from qlikview.
if your data volume is large , i suggest you to implement same logic in qlikview instead of calling stored procedure.
thanks Sunil. sql is very easy but oracle stored procs are proving difficult. it may be that qv cannot do it.
Do you have an example of calling an Oracle stored proc that returns a records set ?
Tod,
Did you finally found out what is the right syntax to call the stored procedure on Oracle?
Sorry, no.
use below
LOAD *;
select
schemaname.SQL CALL sp_name('string1','string2') as output
from schemaname;
thanks sunil,
are you actually using that successfully to load data from an oracle cursor ?
unless i'm misunderstnading your references to schemaname, I do not think that will work.
when calling an oracle SP, you need to set an output variable for the cursor. there is no "from" in an exec call to an oracle SP.
Please let me know if I'm missing something
I did try Sunil code and got:
"SQL##f - SqlState: S1000, ErrorCode: 923, ErrorMsg: [Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected" as Tod suggested.
What now?