Creating Oracle table with XMLTYPE column

If you create a table with an XMLTYPE column

create table test (name varchar2(60), xml_col xmltype) ;

You get the following error message


Error starting at line 22 in command:
create table test (name varchar2(60), xml_col xmltype) 
Error at Command Line:22 Column:0
Error report:
SQL Error: ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "TBS_3"


To work around this problem all you need to do is define the Column storage for the XMLTYPE column to b a clob.


SQL> create table test (name varchar2(60), xml_col xmltype not null) xmltype column xml_col store as clob

SQL> insert into test values ('abc', xmltype('World'));
SQL> select name, extractvalue(xml_col, '/hello') value from test3
Name        Value
-----------------
Hello       World








Comments

Post a Comment

Popular posts from this blog

Spring Framework

Spring is a J2EE framework and aims to simplify J2EE development Lightweight – A non invasive container that can assemble set of loosely coupled POJOs. This allows software components to be tested in isolation Abstract Transaction Manager – Allows for pluggable transaction managers, not tied to J2EE environments JDBC abstratcion layer – meaningfull exception hierarchy (no need to extract vendor codes from SQLException) simplified error handling. Integrartes with Toplink, Hibernate, JDO and iBATIS SQL maps AOP functionality – can AOP any object and add aspects such as declarative transaction management. Transaction management can be done without EJB or JTA A flexible MVC architecture – Can work with Struts, WebWork or Tapestry and accomodates multiple view techonlogies like JSP, Velocity, Tiles, iText and POI Spring uses a setter based dependancy injection pattern (Inversion of Control) See my Spring AOP Sample Book Reference: Pro Spring by Rob Harrop Jan Machacek
Read more

Never use a String

http://stephan.reposita.org/archives/2008/05/02/never-never-never-use-string-in-java-or-at-least-less-often/ An excellent post on why you should minimize using String, int and other Primitive Data Types.One advantage I personally see is in the Code Completion feature of Oracle JDeveloper where it will show me the data type for the methods but not the variable name. One should be careful of not overdoing this approach as it can make your code a lot more verbose.
Read more

JSON Web Token

JWT or JSON Web Tokens can be used for securely transferring data between two apps. You can use this to build a lightweight Single Signon functionality within your webapps. An Introduction to JSON Web Tokens in Plain English
Read more