Oracle: Create schema with table of xml type

Question

in the Oracle database I wanted to create a schema with a table of XMLTYPE.

CREATE SCHEMA AUTHORIZATION xmlAdmin
    CREATE TABLE PossibleAnswers OF XMLTYPE;

In return, I get an error of ORA-00906: missing left parenthesis.

Is there any reason why this is not working?

MT0 · Accepted Answer · 2021-10-29 20:46:43Z

1

You want to create the schema with a table with a column of type XMLTYPE rather than trying to create an object-derived table from XMLTYPE:

CREATE SCHEMA AUTHORIZATION xmlAdmin
  CREATE TABLE PossibleAnswers (value XMLTYPE);

answered Oct 29, 2021 at 20:46

MT0

173k12 gold badges70 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Littlefoot · Accepted Answer · 2021-10-29 20:45:03Z

0

This is what you tried; it won't work:

SQL> create schema authorization scott
  2    create table a of xmltype;
  create table a of xmltype
                 *
ERROR at line 2:
ORA-00906: missing left parenthesis

Though, you can create such a table itself:

SQL>   create table a of xmltype;

Table created.

If you want to create a schema and a table, modify create table statement to e.g.

SQL> create schema authorization scott
  2    create table b (col xmltype);

Schema created.

SQL>

answered Oct 29, 2021 at 20:45

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Collectives™ on Stack Overflow

Oracle: Create schema with table of xml type

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related