Error message after PL/SQL page process
859740May 5 2011 — edited May 5 2011Hi,
I've a function in a package which returns a BOOLEAN. I want to use it in a PL/SQL page process like this:
begin
if not my_package.my_function(my_variable) then
null; -- message
end if;
end;
I would like to use the result of my function to display one of the pre-defined messages: "Process success message" or the "Process Error Message".
To solve this, I think I need to assign a value to a global variable which tells APEX what the result of executing my "Process Source" was. Right?
At first I tried this with exceptions in the function, and an exception in de "process source". But after raising these exception the "process error message" also appears. But I would like to use (only) the "build-in"-messages..... Easier to translate...
Thanks.