Insert new record on view(ORACLE) produces error

4 posts, 0 answers
  1. Richard Koslik
    Richard Koslik avatar
    70 posts
    Member since:
    Apr 2010

    Posted 02 Dec 2010 Link to this post


    I have created the following view in ORACLE (10g):

     select vc.*,
        (select bp_s_name from vw_vcbp where vcbp_s_vc_key=vc_s_key nd vcbp_B_default=1) bp_s_name 
     from vc

    The view shows all fields from the table VC and one additional field BP_S_NAME, which is only for reading. In the .rlinq file I inserted the view and changed the following properties of the column BP_S_NAME:

    - Kind to "PersistentReadOnly"
    - Nullable to "True"

    If I make an insert onto the view directly in Oracle it works, but if I make an insert through my silverlight application there comes an error.
    Meldung: Unhandled Error in Silverlight Application 
    Code: 4004    
    Category: ManagedRuntimeError       
    Message: System.ServiceModel.DomainServices.Client.DomainOperationException: Submit operation failed validation. Please inspect Entity.ValidationErrors for each entity in EntitiesInError for more information.
       bei System.ServiceModel.DomainServices.Client.OperationBase.Complete(Exception error)
       bei System.ServiceModel.DomainServices.Client.SubmitOperation.Complete(OperationErrorStatus errorStatus)
       bei System.ServiceModel.DomainServices.Client.DomainContext.CompleteSubmitChanges(IAsyncResult asyncResult)
       bei System.ServiceModel.DomainServices.Client.DomainContext.<>c__DisplayClassd.<SubmitChanges>b__5(Object )     

    Has anyone already tried to make an insert onto a database view??? How can I solve my problem?

    Thanks for your help,
    regards Richard Koslik

  2. Ady
    Ady avatar
    588 posts

    Posted 07 Dec 2010 Link to this post

    Hello Richard Koslik,

     Inserting into a view should not be a problem. Can you enable debugging and break when you get this exception? What are the contents of Entity.ValidationErrors? Do they provide some more error information?

    All the best,
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  3. DevCraft banner
  4. zongwut somwong
    zongwut somwong avatar
    5 posts
    Member since:
    Mar 2010

    Posted 07 Jun 2012 Link to this post

    I got the same trouble
  5. Ady
    Ady avatar
    588 posts

    Posted 11 Jun 2012 Link to this post

    Hello zongwut,

     Can you provide some more information on the exception; can you inspect the Entity.ValidationErrors ?
    Is it possible to send some sample code so that we can reproduce the exception?

    the Telerik team
    Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Back to Top