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

Tubby
Drop index un1 ;
create index un1 on xx_test (a1,a2,a3) ;
586651
I dont want to drop the index is it possible to alter?
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
Karthick2003
[ALTER INDEX|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1008.htm#SQLRF00805] is beautifully documented.

Thanks,
Karthick.
1 - 5
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,565 views