Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error

[bronwenwhite]

Hi,

Please could someone assist.  We're trying to execute a procedure that is stored in Oracle v12 schema via an OLEDB Oracle v11 Qlikview connection.  When executing the code using Qlikview v12 desktop, we get the below error.

We've uninstalled Qlikview v12, installed  Qlikview v11, then execute of procedure works.

Is there something that Qlikview 11 allows, and Qlikview 12 doesn't regarding execution of a procedure?

Syntax used in Qlikview for Windows V12 :

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=True;User ID=xxxx;Data Source=xxxx;Extended Properties="DSN=xxxx;UID=xxxx;DBQ=xxx;DBA=W;APA=T;EXC=T;XSM=Owner;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;"] (XPassword is xxxxxxxxxxxxx);

sql

execute xxxx.get_members_new (201801, 201806, 'Principal Member');

Thanks in advance.

[balabhaskarqlik]

May be try like this:

Procedure must have a SET NOCOUNT ON

Or you should include it into your QlikView

1. tmpData:   
2. LOAD *;   
3. SQL  
4. SET NOCOUNT ON
5. Exec dbo.QlickView_GetDGlistNewSession