Executing a stored procedure

[#1]

Hi All,

I'm very new to Qlikview, and I was trying to create my first report based on a stored procedure in my MS SQL database.  In other report tools, I would simply write the SQL statement as follows, but I keep getting an error in the edit script function of Qlikview.  Here's my script so far:

ODBC CONNECT TO [Quantim Production] (XUserId is DIUESZFMKC, XPassword is TFSbJEFGNabcWIRKNKLB);
EXEC dbo.sp_RUNScoreEncountersINPATIENT '10/01/2011','5/18/2012','SHEARTIN';

I get connected to the DB OK, and I can do simple Select statements, but I get an "Unknown Statement" when I try to reload using an "EXEC" SQL command.

Any ideas?

-Bob

[#2]

Hi,

Thank you for your inputs!!.

Could you please help in integrating oracle stored procedure data with QlikView.

I have tried all the above changes.

But I am not able to fetch Oracle stored procedure data into QlikView as well as insert records into Oracle table through stored procedure.

I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracl...

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary