PLSQL Clob Document,showing Numeric or value error in the Notification

Oracle Apps Interview Questions › Category: Workflows › PLSQL Clob Document,showing Numeric or value error in the Notification
0 Vote Up Vote Down
Anonymous asked 10 years ago

I’m Using PLSQL CLob Document for printing data in HTML table format in the Notification,even clob variable is capable of storing data up to 4gb ,when i’m trying to print the data greater than 32767bytes (32kb) it is throwing error “Numeric or value Error” .Please help me out to print data >32kb in the notification.Appreciated for the Solution.

Question Tags: ,
1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

You wont get “Numeric or value Error” if there is problem with size. Please copy paste your code here. I will review it.