[Building Sakai] Oracle change LONG to CLOB

[Joshua Swink]

Hi, wondering if I can just change ANNOUNCEMENT_MESSAGE's XML data type
from LONG to CLOB.

While running sakai_2_8_0-2_8_1_oracle_conversion.sql, this is executed:

update ANNOUNCEMENT_MESSAGE set MESSAGE_ORDER='1', XML=replace(XML, '
subject=', ' message_order="1" subject=') where MESSAGE_ORDER is null;

The db responds: ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Not sure why it said expected NUMBER, when that is a character field... but
anyway, it seems like a good solution is to convert XML to a CLOB as
follows:

alter table ANNOUNCEMENT_MESSAGE modify (XML CLOB);

Josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130322/af531685/attachment.html