Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error message after PL/SQL page process

859740May 5 2011 — edited May 5 2011
Hi,



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.

Comments

Sergio-Oracle

$ sudo python -m pip install --upgrade pip

Collecting pip

  Downloading https://files.pythonhosted.org/packages/30/db/9e38760b32e3e7f40cce46dd5fb107b8c73840df38f0046d8e6514e675a1/pip-19.2.3-py2.py3-none-any.whl (1.4MB)

    100% |████████████████████████████████| 1.4MB 700kB/s

Installing collected packages: pip

  Found existing installation: pip 8.1.2

    Uninstalling pip-8.1.2:

      Successfully uninstalled pip-8.1.2

Successfully installed pip-19.2.3

[opc@ow ~]$ sudo python -m pip --version

pip 19.2.3 from /usr/lib/python2.7/site-packages/pip (python 2.7)

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 2 2011
Added on May 5 2011
5 comments
5,569 views