Stored proc error

[#1]

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.

[#2]

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.

[#3]

Can U post a stroed procdure in here?

[#4]

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.

I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracl...

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary