Core Workflow - EBS (MOSC)

MOSC Banner

Unable to display HTML/XML data on email notification body

edited Jun 3, 2009 9:55AM in Core Workflow - EBS (MOSC) 2 commentsAnswered
 Hi,
I a trying to display the clob column (which contains HTML/xml tags and data) in a workflow notification email body.

I created the procedures and functions that will return me the HTML/xml data value as a single column which is stored in the CLOB column and then used "Wf_Engine.setitemattrtext" to set attribute value("ZZ_COST_MESG_DETAIL").
In Workflow when I created a attribute "ZZ_COST_MESG_DETAIL" of type varchar2 and size 4000, I get the following error:

When I run this workflow I am getting the following error:
Error Name = -6502
Error Message = ORA-06502: PL/SQL: numeric or value error

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center