Question

RAISE_EXCEPTION message customization ?

Rating4.4Average

I wonder if it is possible to customize the shape of user messages while using RAISE_EXCEPTION function in PL/SQL.
The project is in Oracle Application HR and the version of the database is Oracle 8. We tried to add some new data verification functionality to the application by using database triggers, but the messages to the user are unbearably awkward: after having a message that something wrong happened, the user presses HISTORY button and gets all possible codes and unfriendly system informaton.
Is it possible to override it?

  1. How modify Oracle function
    Hi, I've function "execute_sync_query". I'd like send mail after update when pAfmTab in ('RACK' or 'EQ_OUT') with where condition in update statement. I create stored procedure: "SEND_NOTIFY_RACK_EQ_OUT" and I have modified the funcion: execute_sync_query_modify BUT I don't Know How c…
  2. Oracle Function not working properly
    Hi, I am a fledgling Oracle developer. I have a function that needs to scroll through some code based on two IN parameters. I need to evaluate row by row, determining whether it is a candidate to count +1, or just to skip through it. It needs to go to a different value for STATCODE, then back again to STATCODE to be counted. I can not get the code to retu…
  3. oracle user liscence
    I am asked to install an oracle database on a new machine. How to go abt acquiring a user lisence for oracle software. does the organization take care of it.
  4. Reliable, Fastest way to export/import user obj…
    Hi, A seed user in oracle 11g db will create all tables in datatblspc1 and all the indexes in idxtblspc01...there could be more than 5000 tables, 25K indexes, 30 TB data in it. Could anyone please advise the reliable, fastest way to export/import these between Oracle 11g Database instances schemas? user objects? like Ta…
  5. User Defined Function not using index
    We are using Oracle 10g R 2. we have a Java user-defined function that I have marked DETERMINISTIC and only depends on the single input parameter. The function accepts a string and returns a date. When the function is used in a where clause against a table, an index on the column referenced in the where clause is used as expected. When th…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
raise_exception oracle
Participating Experts
4
Solution Grade
D

Replies

 
by: mgokman

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: hrproj

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: kittu

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: petevdb

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: hrproj

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: mgokman

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: altena

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: hrproj

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: hrproj

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert