topic Stored proc error in QlikView

Stored proc error

Mon, 01 Jul 2013 12:29:33 GMT

Hi All:

i have created a new Sql server stored proc which runs fine in Sql Server

but when i call this stored proc in QlikView

using

SQL

exec dbo.New_StoredProc @RegionId = 0;

it gives me an error

SQL### - SqlState:37000,ErrorCode 2812,ErrorMsg : [Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored proc

'dbo.New_StoredProc'

SQL

exec dbo.New_StoredProc @RegionId = 0;

All the existing stored proc works fine in QlikView but only this new one gives error.

Any thoughts why i am getting this.

Mon, 01 Jul 2013 12:40:29 GMT

I am trying to execute a stored proc ..not sure how "select from " will help.

Also i am not getting a syntax error. I am executing many stored procs like this.

But getting error only in this newly created stored proc.

stored proc runs fine in the backend.

Tue, 02 Jul 2013 06:44:07 GMT

Can U post a stroed procdure in here?

Thu, 02 Jun 2016 14:19:19 GMT

Hi,

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.

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary