CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-5.1
TeAyudo
TeAyudo

Reputation: 59

Oracle Apex: Validation triggers Process

I have two input forms:

If I click a button, a process is triggered which calls a PL/SQL procedure with these two inputs as parameters.

So the procedure should only be called if the two items do have valid inputs.

If I do this with validation or "Value Required", it's working but the process is still running and I want to avoid that. I tried it with JS and $v to compare the input if its empty or not but it was not working.

I'm working in 18.1 and 5.1 so its not a big difference.

Upvotes: 0

Views: 1242

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

Put validation into PL/SQL procedure and check whether parameters are OK. Something like this (validating whether they aren't NULL; you didn't mention any other validation):

if :P1_INPUT_1 is not null and
   :P2_INPUT_2 is not null 
then
   your_procedure(:P1_INPUT_1, :P1_INPUT_2);
end;

Upvotes: 1

Related Questions