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 OCTOBER 23, 2018

Applies to:

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

Symptoms

Attempting to create a property graph generates this error:

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

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

Cause

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
Symptoms
Cause
Solution


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