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
showing 5 of 6
show 1 more comments
|
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
Hello Yalim,
I did the export. No idea where the file is stored though.
Regards Ajit
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.
=========== 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
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
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