Index out of range?!?!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
HSNMatt
Posts: 18
Joined: Thu 18 Apr 2013 15:30
Location: St Petersburg, FL

Index out of range?!?!

Post by HSNMatt » Tue 14 May 2013 19:42

Hello,

I have a stored procedure which I had to custom map back into entity designer because it can't be called using nulls. It'll return an invalid cursor.

I've created my method to call the stored procedure, created the complex type, and mapped the columns from the database to the parameter names in the complex type. When I go to run the stored procedure, I get the following message:

Code: Select all

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
I'm not sure, but could this have to do with the cursor from the DB having more columns than the complex type has? I'm doing this on purpose, but I can just pull in the added columns if I need to.

Thanks!

HSNMatt
Posts: 18
Joined: Thu 18 Apr 2013 15:30
Location: St Petersburg, FL

Re: Index out of range?!?!

Post by HSNMatt » Wed 15 May 2013 15:33

Followup to the previous post:

I added the remaining column into the complex type and mapped them, and it eliminated the error.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Index out of range?!?!

Post by Shalex » Mon 20 May 2013 08:01

The complex type should have the same set of columns as the corresponding cursor.

Post Reply