Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29549: class SOME.SYSTEM CLASS has changed, Java session state cleared

369038Feb 6 2009 — edited May 5 2009
I am using a javamail program to send emails, and occasionally receive the following:

ORA-29549: class SOME.SYSTEM CLASS has changed, Java session state cleared

This causes the calling program to fail, and pagers go off. I have scoured the internet looking for a way to handle the error. Most discussions I find on this suggest to just call the procedure again and it works the second time. That's true if you call it from a new session, but there is not a way to catch the ora-29549 in plsql and then call the same plsql java wrapper function again - you will again receive ora-29549. Any suggestions on how to get around this one? I need to be able to catch the error and handle it by successfully sending out the emails. One workaround I had thought of was to call this java mailer every morning and send a dummy email to myself, so that if the process fails it is not failing for a production-critical process. That seems like a pretty rudimentary workaround - I would think it should be possible to handle the error in plsql somehow. Since there was not much out there on the web I thought I would begin this thread. Any suggestions are greatly appreciated - thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2009
Added on Feb 6 2009
4 comments
8,943 views