Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wcf Data Service fails when more than 8properties in the 'select=' portion

925011Mar 19 2012 — edited Aug 18 2012
Hi:

I am using WCF Data Service and Oracle

EF Provider is ODAC11.2 Release 4

Wcf Data Service fails when more than 8 properties are specified in the 'select=' portion of the URI

here is my code

var q = from c in this.ctx.SALESORDER_ITEM
select new
{
c.SORDERDETAILID,
c.IID,c.DMFLAG,c.OWNERID,c.SKUID,c.SKU_ID,c.TRADENO,c.SOURCEID,c.SORDERID
};

excetion:

InvalidOperationException: An error occurred for this query during batch execution. See the inner exception for details

The inner exception is null, but the DataServiceClientException states: Value cannot be null Parameter name: value

the exception is thrown in base.OnStartProcessingRequest(args) method (overridden).

Here is the call stack as well:

at System.Data.Services.WebUtil.CheckArgumentNull[T](T value, String parameterName)

at System.Data.Services.Internal.ProjectedWrapper.set_PropertyNameList(String value)

at lambda_method(Closure , Shaper )

at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)

at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()

at System.Data.Services.Internal.ProjectedWrapper.EnumeratorWrapper.MoveNext()

at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService)

at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)

at System.Data.Services.DataService`1.HandleRequest()


Is there a max number of properties in $select statement

I think may be it is oracle provider's problem ,but i don't konw how to debug it Can anyone help me

Any help is greatly appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2012
Added on Mar 19 2012
23 comments
1,003 views