ORA-01450: maximum key length (3118) exceeded

From: Eric Robertson <erobert2_at_gmu.edu>
Date: Wed, 16 Jul 2003 11:55:14 -0400
Message-ID: <bf3sh2$tic@portal.gmu.edu>

I get this error while trying to create an index on an XMLType column:

CREATE INDEX bot_data_source_idx ON BOT_DATA

(vuln.extract('/sourceid').getStringVal());

The XMLType column as specified by a schema where sourceid is restricted to 40 characters. The underlying object type also conforms to the restriction using varchar2(40) as the data type.

By block size for the database is 4092.
Why does extract() to retain the length restriction in the XMLType fragment it returns so the index creation command can recognize that the key length will not be exceeded? Received on Wed Jul 16 2003 - 10:55:14 CDT