Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. krzyzowiec

    Error handling in VB/oracle using stored procedures for DML

    I guess you are trying to insert a record into some table. If this is the case check what fields are required in the table and then before inserting it do an error check in VB program to catch those null fields.
  2. krzyzowiec

    error escalating

    Thanks, I tried this one, too. This is a great tool; however, in order to use it with Oracle Apps, I would have to change the form code by adding DBMS_ALERT.WAITONE procedure to catch the alert message but, as I mentioned before, I cannot touch it.
  3. krzyzowiec

    error escalating

    sem, I was told to not change form's code. My trigger does not belong to the application. It's on a server side. When it fails an application displays a message but it is not meaningful. I've been looking for a solution to tell the user that there was a problem. I wonder if there is a way to...
  4. krzyzowiec

    error escalating

    Thanks for your help. I did use the RAISE_APPLICATION_ERROR procedure and when a trigger fails a popup window shows some error message but I've got a feeling that a user can ignore it and proceed. What I need is a significant error message for a user. The ideal solution would be to stop the...
  5. krzyzowiec

    error escalating

    Can a trigger sitting on a table raise a FORM_TRIGGER_FAILURE? If not, how can one display an error message sent from a trigger to the application user?

Part and Inventory Search

Back
Top