My Oracle Support Banner

OPG_APIS.CREATE_PG fails with ORA-00910: specified length too long for its datatype (Doc ID 2463898.1)

Last updated on APRIL 01, 2020

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


Attempting to create a property graph generates this error:

opg_apis.create_pg('myGraph', dop => 4, num_has_ptns => 8, tbs => 'USERS', options => 'COMPRESS=T');

Error report -
ORA-00910: specified length too long for its datatype
ORA-06512 at "MDSYS.OPG_APIS", line 1444
ORA-06512 at "MDSYS.OPG_APIS", line 1116
ORA-06512 at "MDSYS.OPG_APIS", line 1107
ORA-06512 at "MDSYS.OPG_APIS", line 464
ORA-06512 at line 2
00910. 00000 - "specified length too long for its datatype"
cause: for datatypes CHAR nad RAW, the length specified was > 2000; otherwise the length specified was 4000
action: use a shorter length or switch to a datatype permitting a longer length such as a varchar2, long char or long raw


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.