Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

can QlikView load data from an oracle stored procedure ?

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

7 Replies
suniljain
Honored Contributor

can QlikView load data from an oracle stored procedure ?

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.

Not applicable

can QlikView load data from an oracle 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 ?

hrdzpqkv
New Contributor II

can QlikView load data from an oracle stored procedure ?

Tod,

Did you finally found out what is the right syntax to call the stored procedure on Oracle?

Not applicable

can QlikView load data from an oracle stored procedure ?

Sorry, no. 

chauhans85
Esteemed Contributor

can QlikView load data from an oracle stored procedure ?

use below

LOAD *;

select

schemaname.SQL CALL sp_name('string1','string2') as output

from schemaname;

Not applicable

can QlikView load data from an oracle stored procedure ?

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

hrdzpqkv
New Contributor II

can QlikView load data from an oracle stored procedure ?

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?

Community Browser