Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master
Master

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
Author

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 ?

Anonymous
Not applicable
Author

Tod,

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

Not applicable
Author

Sorry, no. 

SunilChauhan
Champion
Champion

use below

LOAD *;

select

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

from schemaname;

Sunil Chauhan
Not applicable
Author

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

Anonymous
Not applicable
Author

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?