Relative Content

Tag Archive for oracleoracle-apex

how to create multi select list in oracle apex?

I have a table called Employees with Employee_id , Employee_Name columns,job,and product. Now i want to create a page to insert these data. the item for product with type of select list or LOV and allow multi select, store thes values i had selected into a database column in a table . The problem i am facing is to how to create that multi select list and store the select values in these table.i tried to do that using column data type “varchar 2” and in the specification of page item i have used the multi select is “yes”
Is there an Item for multi select? If not, how should i do it?

Oracle Apex – Interactive grid not updating validations if save button is clicked more than once after new rows inserted

I am on Oralce Apex 22. I have an issue with my IG. For my grid, I validations for some of the columns that are simple type=”Column is not null” and that “Display inline and in notification”. When I first load the page, if I add rows with missing values in the columns, click save, the cells get highlighted in red and the errors show up in the yellow notification box as expected:

ORA-22905: cannot access rows from a non-nested table item

I use Oracle Apex 23.1.0.
I have a Classic Report , it calls a function from my package.
I should use Facet Search on some of columns Report .
when I set function parametr Constantly , it will be OK.
but when I use Page Item for function parametr , I will get Error .

Search interactive report for values appearing in sql on other page

So I am making a interactive report (IR) on a page (lets say page 2) that shows a certain set of values from different tables. Each row has a unique number and when you click on that number it opens a modal page (page 3) with a new report from a new query. I was wondering if it is possible to search on page 2 for values in page 3. So for instance i am a looking for a specific number that is available on page 3 (because otherwise the query of page 2 would get too cluttered), its corresponding unique number would show up on the IR in page 2, then i click on the number to open up the modal page where the value appears that I was looking for.