Getting the following errror when two people edit the same row

1-User-Defined Exception-21000-ORA-21000: error number argument to raise_application_error of 1 is out of rangeORA-21000: error number argument to raise_application_error of -21000 is out of range

Datasource is based on a view and that view has an "instead of" trigger associated with it. Have put debug code into the "instead of" trigger and the code never gets that far. Error is happening when we get perform api_datasource.docommit('V_RRA1');

I can't find -21000 anywhere in any of our code.

asked 12 Nov '15, 03:24

apacheuk's gravatar image

apacheuk
139220
accept rate: 0%


Doh!

Figured it out, we weren't handling the api_exception.e_concurrencyViolation correctly.

Thanks for your patience :)

link

answered 12 Nov '15, 05:34

apacheuk's gravatar image

apacheuk
139220
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

By RSS:

Answers

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

Tags:

×61
×43
×9
×1

Asked: 12 Nov '15, 03:24

Seen: 775 times

Last updated: 12 Nov '15, 05:34


© Copyright Gerger 2017