This content has been marked as final. Show 4 replies
Instead of the RAISE_APPLICATION_ERROR command, just replace that with RAISE;
The error is coming out of the package that is sending the notification (WF_NOTIFICATION), which is invoked when you open the notification. I'm guessing that line 5 is the line in your code though.
Are you using documents to send the notification, or are they purely defined in the .wft file?
Alpha review chapters from my book "Developing With Oracle Workflow" are available on my website:
NEW! - WorkflowFAQ Blog at http://thoughts.workflowfaq.com
Typically an exception from within WF_NOTIFICATION package is caused when you have defined a PLSQL or PLSQLCLOB document type message attribute to generate the notification message body. Any uncaught exceptions from within your PLSQL Document API is raised to the notification details page.
Please use only RAISE; within "WHEN OTHERS THEN" after setting the context. Also, please check if your PLSQL Document API is right?
Thank you. Actually I had missed out an attribute in the message body, which was causing this error.
Hi can you please say which attribute you missed in the message body? Because I'm facing the same issue ORA-20006 error