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
1.0k4
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 ===========

create or replace PACKAGE BODY CONCURRENCY_PKG AS

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.');

END SAVE;

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

END CONCURRENCY_PKG;

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,
Yalim

link

answered 07 Apr '16, 16:17

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 22%

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:

×43

Asked: 06 Apr '16, 08:43

Seen: 710 times

Last updated: 12 Apr '16, 00:00


© Copyright Gerger 2017