Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Primary/Foreign Key Error which
goto150
... But if you really want to go with custom error handling function, it is enough if you copy Example of an Error Handling Function from Oracle Doc here : Documentation and use it as described in one in your earlier post in this theread. In Oracle doc it's explain in details how to adjust it and whRead more
... But if you really want to go with custom error handling function, it is enough if you copy Example of an Error Handling Function from Oracle Doc here : Documentation and use it as described in one in your earlier post in this theread. In Oracle doc it's explain in details how to adjust it and where so that it will serve your need.
When I used it basicaly as it is, with only 1 small adjustment for I was not patient enough to create my own CUSTOM error table:
I get this when violating FK:

I guess it is worth to try each those 2 and use the one that best fits your needs
See lessPrimary/Foreign Key Error which
goto150
Hi Hussain, I have this simple FORM on page 61 with DELETE button triggering Delete process: BEGIN DELETE FROM DEPT WHERE DEPTNO = :P61_DEPT_DEPTNO; END; :P61_DEPT_DEPTNO is page item labeled Dept Deptno here in the screen and you may see that while trying to fire Delete process I get standard errorRead more
Hi Hussain,
I have this simple FORM on page 61 with DELETE button triggering Delete process:
:P61_DEPT_DEPTNO is page item labeled Dept Deptno here in the screen and you may see that while trying to fire Delete process I get standard error.

Here is the place where validation comes on the stage. In Proccessing section of the page I click Validation and Create Validation:
So now instead of standard error you'll see the one you just created.

See lessHow to check if the entered value does not already exist in Oracle Apex?
goto150
Interactive Grid. Solution that I used to find duplicates among newly entered records for the MGR field I wanted to keep unique. Right click on the MGR column and select Create Validation. Type = Function Body (returning Boolean) Language = PL/SQL PL/SQL Function Body: declare ln_count number :=0; bRead more
Interactive Grid.
Solution that I used to find duplicates among newly entered records for the MGR field I wanted to keep unique.
Right click on the MGR column and select Create Validation.
I must guarantee my collection exists. To do that I am going to create Dynamic Action with PL/SQL code:
Dynamic Action is going to be fired by Event = Save [Interactive Grid] with Fire on Initialization = TRUE (I need it even before the first Save action, just after my page gets loaded).
Reference:
APEX Collection.
Primary/Foreign Key Error which
goto150
I was rather thinking of something like... I have a page item called P10_Serial_Number of Text type and I let user to edit it. My table Products, I insert P10_Serial_Number to, accepts only unique values for the SN field... Is there a way to customize an error message in case unique constraint is brRead more
I was rather thinking of something like...
I have a page item called P10_Serial_Number of Text type and I let user to edit it. My table Products, I insert P10_Serial_Number to, accepts only unique values for the SN field... Is there a way to customize an error message in case unique constraint is breached? I tried solution proposed in Foxinfo... but instead of getting what author described as custom error, I get this and that...
What I am trying to say is that you have your "use case" in front of you, so why not put it here?
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex when select row@selector?
goto150
You just need to remember that what this code actually does is with every selection change it loops through all the records and: IF see selected it set collection = service charge. (even if collection was modified by user it will still be replaced with service charge with next selection change deteRead more
You just need to remember that what this code actually does is with every selection change it loops through all the records and:
I am not saying it does not do what you wanted, but before you apply it, please analzie it carefully and adjuste it to your needs.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex when select row@selector?
goto150
I have a feeling that you disliked my idea of using Action button:) Maybe this piece of code is going to serve your need. Revert changes for deselected row: var view = apex.region("SID_COLLECTION_LIST").widget().interactiveGrid("getViews","grid"); var model = view.model; var selectedRecords = view.gRead more
I have a feeling that you disliked my idea of using Action button:)
Maybe this piece of code is going to serve your need.
Revert changes for deselected row:
See lessPrimary/Foreign Key Error which
goto150
It would be easier if you were more specific about the case you're dealing with.
It would be easier if you were more specific about the case you're dealing with.
See lessMaster Detail View(Report Total is not appearing)
goto150
Check template that is used for your page item, you'll find it in Appearance section. Your label may disappear for instance if you have your template = Hidden and and Label Column Span for this Page Item is 0.
Check template that is used for your page item, you'll find it in Appearance section. Your label may disappear for instance if you have your template = Hidden and and Label Column Span for this Page Item is 0.
See lessPrimary/Foreign Key Error which
goto150
Try validations.
Try validations.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex when select row@selector?
goto150
Hi Hasem, I am not a big fan of overcomplicating simple things, why don't you use a native feature which is revert changes? Action -- > Selections -- > Revert Changes.
Hi Hasem, I am not a big fan of overcomplicating simple things, why don't you use a native feature which is revert changes? Action -- > Selections -- > Revert Changes.
See less