topic Re: Error calling a stored procedure in QlikView

Error calling a stored procedure

Anonymous — Thu, 01 Nov 2012 19:15:44 GMT

Hi guys..

Trying to run a fairly simple stored procedure from QV

QueryTable:

Load

SQL $(vSQL);

I set my $(vSQL); in a button with action like:

= 'exec [DB].[dbo].[sp_trace] @batch = ' & chr(39) & vBatchID & chr(39)

vBatchID is set via inputbox.

The $(vSQL) ends up like:

exec [DB].[dbo].[sp_trace] @batch = '22081210212296004'

Running this from ms sql returns data.

But when I try to execute in QV I get this:

Error: File extdata.cpp, Line 2777

SQL EXEC [DB].[dbo].[sp_trace] @batch = '22081210212296004'

I do not see why????

Any advise

Dan

MayilVahanan — Thu, 01 Nov 2012 19:20:11 GMT

Please go through this link..

edit:

try like this

LOAD *;

SQL EXEC sp_text '20100101','20100530';

Anonymous — Thu, 01 Nov 2012 19:35:06 GMT

Hi.

I have read that thread it provides no help to me at all.

I testet with

exec sp_who and that runs as it should.

MayilVahanan — Thu, 01 Nov 2012 19:56:38 GMT

I tried with select statement in variable using action button and reload it.. it works.

May be it helps..

lukas_sokol — Tue, 16 Feb 2016 22:01:45 GMT

I have similar problem and when I use ODBC instead OLEDB Connect then it works.