I've got a strange one that can't seem to figure out.

I have a grid based on a complex view with an "instead of" trigger on the database. I can issue DML on the view from sql plus no problem no errors occur.

When issuing a api_datasource.doCommit statement I keep getting the above oracle error ORA-01422. I can see that my instead of trigger is completing as I've put debug in, my question is does the api_datasource.docommit process do some kinda (perhaps query back rows commited or something) check after comminting the data that could be causing this issue???

asked 04 Feb '16, 09:13

apacheuk's gravatar image

accept rate: 0%

Doh, figured it out....

View was a child of a parent and I had the wrong field set for the primary key, so it looks like the docommit does perform some check

note to self, try to use not so similar field names in the future.... mta_id and mla_id :)


answered 04 Feb '16, 09:17

apacheuk's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Feb '16, 09:13

Seen: 1,595 times

Last updated: 04 Feb '16, 09:17

© Copyright Gerger 2017