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!

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

Impromtu 6.0 to display Oracle Error Message

Status
Not open for further replies.

wongaw

Technical User
Feb 20, 2002
1
AU
Hi All,

I have an Oracle package with stored procedures which I call from Impromptu Query, it works very well if there is no exception raised. However, when an user exception is raised, the Oracle Error Message doesn't get display.

For example, I raise an application exception with the following code:
Code:
  raise_application_error(-20000, 'My Oracle Application Error Message');

Impromtu displays just "ORA-20000", but not the error message.

All helps are welcome!!

Thanks!

- al
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top