Display string from raise_application_error in java program

Question

I am raising some application errors from PL/SQL procedures. I am setting some messages for instance,

RAISE_APPLICATION_ERROR(-20001, 'message');

Is there any way, I can display 'message' in exception section in catch block of java program from which I called this procedure?

Ed Gibbs · Accepted Answer · 2013-04-29 14:55:53Z

3

If you're doing catch (Exception e), message should be available from e.getMessage().

If you're doing catch (SQLException e) (or whatever the exception type is for your data access package) message should still be available from e.getMessage(). Additionally, the -20001 should come through in e.getErrorCode(). Note that it may come through as the absolute value (20001 as opposed to -20001); you'll have to experiment.

answered Apr 29, 2013 at 14:55

Ed Gibbs

26.4k4 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:30:58Z

1

I think this post will help you out: Error catching

catch (GenericJdbcException ge) {

IF (se.getErrorCode() == -20001)

If your not using Hibernate you might need to change the error type.

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Apr 29, 2013 at 14:53

Edwin Stoteler

1,2271 gold badge11 silver badges25 bronze badges

Collectives™ on Stack Overflow

Display string from raise_application_error in java program

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related