topic Re: Problem with StoredProc in QlikView

Problem with StoredProc

Mon, 26 Jan 2026 21:26:37 GMT

Hello

I have simple oracle storedproc, it succeeds in Toad: exec shemaname.test(1);

But I can't run it in QV ;( Pls, HELP!!!

I gave script permission to read / write

With my ODBC CONNECT I can get the data from the table:

test:

LOAD *;

SQL

select * from mapping;

But I can not start the StoredProc ;(

I have tried to do this:

test:

LOAD *;

SQL

select TEST(1) from dual;

test:

LOAD *;

SQL

exec TEST(1);

test:

LOAD *;

SQL

call TEST(1);

test:

LOAD *;

SQL

begin

exec TEST(1);

end;

I always get an errors:

I added a data source right on stored procedures

I do not understand what I'm doing wrong ;(

Re: Problem with StoredProc

Wed, 07 Aug 2013 09:36:13 GMT

also

test:

SQL

exec TEST(1);

test:

SQL

exec dbo.TEST(1);

;(((

My stored procedure without returning any recordset: (non query)

Running a stored procedure without returning any recordset: (non query)
Use the function CALL to specify the name of the stored procedure.
Example (Launches XYZ with the two parameters 2 & 5):
sql call XYZ ( 2 , 5 );
This works for both ODBC and OLE DB. However, when opening the connection using OLE DB, make sure to add (mode is write) before the finishing semi colon in the connection string.

and it still does not work:

sp:

SQL CALL TEST2;

Re: Problem with StoredProc

Wed, 07 Aug 2013 14:50:33 GMT

test:

SQL

EXEC "ShemaName".TEST '1';

Thanks to myself.