Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error

bronwenwhite — Wed, 25 Jul 2018 12:42:42 GMT

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.

Re: Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error

BalaBhaskar_Qlik — Wed, 25 Jul 2018 16:58:24 GMT

May be try like this:

Procedure must have a SET NOCOUNT ON

Or you should include it into your QlikView

tmpData:
LOAD *;
SQL
SET NOCOUNT ON
Exec dbo.QlickView_GetDGlistNewSession

topic Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error in QlikView

Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error

Re: Oracle Execute Procedure using Qlikview for Windows v12 - ODBC error