hello All,

I am a newbie here. And am trying my hand at saving an updated record.

I get this message while using api_application.showPopupMessage('test');

ora-31020: The operation is not allowed, Reason: Invalid pl/sql DOM handle.

The api_application.docommit does not work either.

Regards, Ajit

asked 06 Apr '16, 08:43

Ajit%20Mathew's gravatar image

Ajit Mathew
accept rate: 0%

closed 12 Apr '16, 00:00

Hi Ajit,

Could you please attach, paste your applications export file here along with the PL/SQL code you wrote for the application.

Kind Regards, Yalim

(06 Apr '16, 09:01) Yalim ♦♦

Hello Yalim,

I did the export. No idea where the file is stored though.

Regards Ajit

(06 Apr '16, 09:07) Ajit Mathew

Hi Ajit,

Try using Chrome. When you finsh the export, the browser starts a download of the file and in Chrome, you can access this file from the bottom of the browser window. It is usually in the default download folder of your computer.

(06 Apr '16, 09:13) Yalim ♦♦

=========== PASTE - III ===========


PROCEDURE SAVE AS BEGIN api_application.docommit(); exception when api_exception.e_concurrencyViolation then api_application.showPopupMessage('This dept has already been edited by another user. Please click "Refresh" to access most recent details.');


procedure refresh as begin api_datasource.refreshCurrentRow('DEPT1'); end;


Regards, Ajit

(07 Apr '16, 02:19) Ajit Mathew

Hello Yalim,

I got it working now. Chrome made life a lot more easier for me. Sorry for the trouble. There is one issue though. The exception api_exception.e_concurrencyViolation isnt firing. No probs i will figure that out too. Thanks and regards

Regards, Ajit

(07 Apr '16, 03:52) Ajit Mathew

Hello Yalim,

The e_concurrencyViolation exception is now firing. I had missed reading about the before update triger. All is fine now. Thank you,

Regards, Ajit

(07 Apr '16, 04:40) Ajit Mathew
showing 5 of 6 show 1 more comments

The question has been closed for the following reason "Solved" by Ajit Mathew 12 Apr '16, 00:00

Hi Ajit,

Happy to hear that the issue is resolved! :-)

Kind Regards,


answered 07 Apr '16, 16:17

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

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: 06 Apr '16, 08:43

Seen: 1,169 times

Last updated: 12 Apr '16, 00:00

© Copyright Gerger 2017