This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
I am migrating from hsqldb to oracle for JMS message persistence. However, the table, JMS_MESSAGES, CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
the OBJECT type of MESSAGEBLOB column is not available in oracle.
Can anyone tell me which data type of MESSAGEBLOB should be used instead of OBJECT type in oracle database?