CODEWITHSUNDEEP
sqloracle-databaseexceptionplsql
Natha Kamat
Natha Kamat

Reputation: 81

Display string from raise_application_error in java program

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?

Upvotes: 1

Views: 4329

Answers (2)

Ed Gibbs
Ed Gibbs

Reputation: 26343

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.

Upvotes: 3

Edwin Stoteler
Edwin Stoteler

Reputation: 1228

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.

Upvotes: 1

Related Questions