Hi everyone !
I'm new to APEX and i need to make a data loading page for my app. My app should upload data into a table, and I have to create a data validation. In every table that I upload, I have one column named CATEG. So, if only one row in the CATEG column didn't have the value "B2B" then the table will not pass the validation and it should be generated an error message. Otherwise, if only one row from the CATEG column have the value "B2B", then the data will be loaded without any errors. How to do this ? Please help !!! I tried something like this:
-PL/SQL function returning boolean : BEGIN
IF :CATEG = 'B2B' THEN
and then i have write an error message in the "error message" box
-PL/SQL function returning error text : BEGIN
IF :CATEG != 'B2B' THEN
None of these two didn't work. Could you please help me and tell me what is wrong? I need desperate help!
Hmm ok first off if you use the notation :CATEG then you need to have an actual item called CATEG. Unless there is an application item its unlikeley your item is called that way. Page items are usually called PX_CATEG. So check if the item exists under that name, and if it doesn't then use the correct name in your code.
Click Session and see if it actually has the value 'B2B'
After submitting the page, Please click on Session from 'Developer Toolbar' and check the value for the item P5_CATEG. If the value not exists in that session then your validation will not work. Plz check and confirm.
In case value is not exists for that item in session then try to create dynamic action to set the value for that item.
PS: Change your name in forum instead of number.