Displaying Oracle database error msg in Form 6i

5 pts.
Tags:
Oracle error messages
Oracle Forms
Oracle Forms 6i
I want to display Oracle Database generated error msg in my Form 6i application

Software/Hardware used:
OS-Windows 2003 Server, HW- Any PC, Oracle 10g Database, Developer 2000, Form 6i

Answer Wiki

Thanks. We'll let you know when a new response is added.

More details would be needed to provide an accurate answer.

There is a SQLERRM pl/sql function that you could use inside an exception handler to get the Oracle error text.

In your Forms application you could display it with the MESSAGE built-in procedure, with an alert, or assigning it to some item.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • AshifToday
    get oracle error constants
    sqlcode, sqlerrm
    there are also some form 6i constants as well
    error_text, error_code and error_type

    these can be used to get the errors.

    i also found a library , that not directly output the error, but you can use it to display any sort of alerts / warnings / error by using string variables. you can find PLL library at : http://software.visititech.com/developer-tools/oracle-forms-6i-alerts-library/
    10 pointsBadges:
    report
  • mamumu
    I have the same problem.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following