Mark,
Thanks for the tip.

I am trying to update the view and it works great until I exceed 4000 characters. I get the message ORA-00997 Illegal use for long datatype. Do you know why I might receive this error? Have you successfully updated a view with more than 4000 characters?

Matt