{"id":2268,"date":"2016-09-23T21:35:16","date_gmt":"2016-09-23T18:35:16","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2268"},"modified":"2017-02-15T21:37:20","modified_gmt":"2017-02-15T18:37:20","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-19000-to-ora-19200","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-19000-to-ora-19200\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200<\/strong><\/p>\n

\n
ORA-19000: missing RELATIONAL keyword<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply the RELATIONAL keyword in the storage clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-19001: Invalid storage option specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid storage option was specified for the XMLType.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply a valid storage option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19002: Missing XMLSchema URL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A XML schema URL must be specified in the storage option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a URL for the XMLSchema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19003: Missing XML root element name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A root element in the XMLSchema must be specified if the XML schema is given.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a root element in the XML schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate storage option for the XMLType column was specified<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a single storage option for an XMLType column<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-19005: Duplicate XMLType LOB storage option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate storage option for the XMLType column was specified<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a single storage option for an XMLType column<\/span><\/span><\/p>\n

\n
<\/a> ORA-19006: XMLType TYPE storage option not appropriate for storage type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The TYPE option can only be used in case of OBJECT RELATIONAL storage option<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the TYPE option or specify an OBJECT RELATIONAL storage for the XMLType column<\/span><\/span><\/p>\n

\n
<\/a> ORA-19007: Schema\u00a0string<\/i>\u00a0does not match expected\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given XML document conformed to a different schema than expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Insert\/Update only the XML documents that conform to that particular schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19008: Invalid version of the XMLType<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid version of the XMLType was found.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is possibly due to data corruption or an internal error or running an older client against a newer version of the database. Ensure that the version of the client can understand the XMLType in the database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19009: Missing XMLSchema keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XMLSchema keyword is missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the XMLSchema URL and element name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19010: Cannot insert XML fragments<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0XML fragments got from extractNode cannot be inserted into the database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Convert the fragment into a proper XML document before insertion.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19011: Character string buffer too small<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The string result asked for is too big to return back<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Get the result as a lob instead<\/span><\/span><\/p>\n

\n
<\/a> ORA-19012: Cannot convert XML fragment to the required datatype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A conversion to a datatype was requested which cannot be performed<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The XMLType may contain fragments and other elements which cannot be converted to the appropriate datatype.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19013: Cannot create VARRAY columns containing XMLType<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a VARRAY column which contains a XMLType<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You cannot store VARRAYs containing XMLTypes in tables. Use nested tables instead<\/span><\/span><\/p>\n

\n
<\/a> ORA-19015: Invalid XML tag identifier (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid XML identifer was detected during XML generation<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the offending tag to not contain characters or symbols that are not allowed by the XML specification<\/span><\/span><\/p>\n

\n
<\/a> ORA-19016: attributes cannot occur after element specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attributes specified using the “@” identifier can only occur before any other element definition when creating XML<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the order of the types so that the attributes occur in the begining<\/span><\/span><\/p>\n

\n
<\/a> ORA-19017: Attributes can only be simple scalars<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attribute values can only be simple scalar values<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only simple datatypes for attribute values<\/span><\/span><\/p>\n

\n
<\/a> ORA-19018: Invalid character in XML tag ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A tag name was found to have an invalid XML character during XML generation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that the generated XML tag, corresponding to a column name or alias, contains only valid characters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value of context passed to GETXML was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that the value of context passed to GETXML is valid.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19020: invalid dereference of XMLType columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to dereference the attributes of an XMLType column which is not part of a base table<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You can only dereference the attributes of a base table XMLType column<\/span><\/span><\/p>\n

\n
<\/a> ORA-19022: Unoptimized XML construct detected.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XMLOptimizationCheck variable was enabled and an unrewritten XML construct was detected. This prevents execution of the XML construct.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the XML construct is being optimized. See the trace file for further information. Disable the XMLOptimizationCheck variable if you want the unoptimized XML operation to be executed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The first argument passed to the update value operator was not an XMLTYPE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that the first argument to the UPDATEXML operator is XMLTYPE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19024: Cursor expression must be named<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value of context passed to GETXML was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that the value of context passed to GETXML is valid.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19025: EXTRACTVALUE returns value of only one node<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Given XPath points to more than one node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that exactly one node is returned.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19026: EXTRACTVALUE can only retrieve value of leaf node<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Given XPath does not point to a leaf node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that a leaf node is returned.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19028: Invalid ADT parameter passed to toObject() function<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object passed as ADT parameter to sys.XMLType.toObject() is not the same type, or a super-type, of the mapped type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Pass an object of the correct type to toObject().<\/span><\/span><\/p>\n

\n
<\/a> ORA-19029: Cannot convert the given XMLType to the required type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The passed in XMLType could not be convert to the required type<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Binary XMLtype instances or other objects cannot be converted to the required object or collection types.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19030: Method invalid for non-schema based XML Documents.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The method can be invoked on only schema based xmltype objects.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t invoke the method for non schema based xmltype objects.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19031: XML element or attribute\u00a0string<\/i>\u00a0does not match any in type\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The passed in XML tag does not match any in the object type<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Pass a valid canonical XML that can map to the given object type<\/span><\/span><\/p>\n

\n
<\/a> ORA-19032: Expected XML tag\u00a0string<\/i>\u00a0got\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When converting XML to object, a wrong tag name was present<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Pass a valid canonical XML that can map to the given object type<\/span><\/span><\/p>\n

\n
<\/a> ORA-19033: schema specified in the XML document does not match the schema parameter<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When creating schema-based XML, the schema specified in the XML document is different from the schema passed in as the ‘schema’ parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the schema parameter to match the schema specified in the XML document.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19034: Type not supported during schema generation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object type contained a type that is not supported for schema generation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a different type or do not generate a schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19035: Invalid select item of the query in newContextFromHierarchy()<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query did not have a number select item followed by an XMLType select item only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the result set of the query used in the newContextFromHierarchy() function has only two selected items: the first item must be number type and the second item must be XMLType.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19036: Invalid query result set in newContextFromHierarchy()<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The result set of the query used in the newContextFromHierarchy() function did not have the same property as the result set generated by a CONNECT BY query.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the query used in the newContextFromHierarchy() function is a CONNECT BY query or that the query returns a result set having the same property as the result set generated by a CONNECT BY query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19037: XMLType result can not be a fragment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The select item of the query in the newContextFromHierarchy() function was an XML fragment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the select item of the query in the newContextFromHierarchy() function is not an XML fragment.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19038: Invalid opertions on query context<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SetMaxRows, SetSkipRows, SetRowTagName opertions are applied to a query context created from newContextFromHierarchy().<\/span><\/span><\/p>\n

Action:<\/b>\u00a0SetMaxRows, SetSkipRows, SetRowTagName opertions can not be applied to a query context created from newContextFromHierarchy().<\/span><\/span><\/p>\n

\n
<\/a> ORA-19039: Keyword\u00a0string<\/i>\u00a0reserved for future use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword is reserved for future use as a builtin function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the name mentioned above to a different one.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19040: Element\u00a0string<\/i>\u00a0does not match expected\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given XML document had a different root element than expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Insert\/Update only the XML documents that conform to that particular schema and element.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19041: Comment data cannot contain two consecutive ‘-‘s<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given comment string expression has two consecutive ‘-‘s.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify comment string to eliminate one or both of the consevutive ‘-‘s.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19042: Enclosing tag\u00a0string<\/i>\u00a0cannot be xml in any case combination<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given enclosing tag matched ‘xml’ in some case combination<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the enclosing tag so that it is not xml in any case combination.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19043: Multiply nested XMLROOT function disallowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An XMLROOT function has an operand that is also an XMLROOT function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the query so that there are no multiply nested XMLROOT functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19044: character length specified for XMLSerialize is too small.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An XMLSerialize function was called with a type of character type (e.g. VARCHAR2(27)), and the length specified (27 in the example) was too small.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the query so that the character length specified is larger.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19045: character set id specified for XMLSerialize not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An XMLSerialize function was called with an invalid value for the caracter set id.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the query so that the character set id is valid.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19046: Out-of-line table cannot be shared by two top-level tables (table ‘string<\/i>.string<\/i>‘ and the current table being created).<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to share an out-of-line table between two top-level tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the existing top-level XML table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19047: Cannot specify storage for individual VARRAYS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to combine storage specification for a particular VARRAY with STORE ALL VARRAYS clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify storage for individual VARRAYs or use the STORE ALL VARRAYS clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19048: Cannot specify VARRAY storage in tableProps<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to store all varrays as tables or LOBs in tableProps.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify varray store as tables or LOBs in tableProps.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19051: Cannot use fast path insert for this XMLType table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Error while trying to insert into an XMLType table using fast path insert.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set event 19049 to disable fast path insert and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19055: Unsupported use of DISABLE XML EXCHANGE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The option, DISABLE XML EXCHANGE, was specified in a CREATE TABLE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify DISABLE XML EXCHANGE in a CREATE TABLE statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19057: Internal error: binary XML [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The operation failed due to an internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19058: Enabling XML exchange may cause data corruption.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to enable XML exchange for a binary XML column or table with a conflicting binary XML column or table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the XML exchange option only if at least one of the two involved tables is empty.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19059: XML exchange has not been enabled.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to disable XML exchange on a table that does not have XML exchange enabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the disable XML exchange option only if the table already has XML exchange enabled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19060: Operation disallowed on XML token set object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform a disallowed operation on a token set object for binary XML support.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform the attempted operation on an XML token set object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19061: Granular Token Set operations are not supported for tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform some Granular Token Set related operations on a non-binary XML table or on an older binary XML table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform the attempted operation unless tables support Granular Token Set options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19062: XML exchange is already enabled.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to enable XML exchange on a table that had XML exchange already enabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the disable XML exchange option only if the table has XML exchange disabled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19063: Granular token table does not support schema-based storage.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use granular token tables with schema-based storage.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use non-schema based storage for granular token tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19064: Tablespace has XML token set objects used in another tablespace.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The tablespace contained an XML token set object that was used by a binary XML table in a different tablespace and dropping it would cause some data to be lost.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Move the XML token set object to a different tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19065: cannot drop tablespace with XML token set while XDB tablespace is offline<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The tablespace contained an XML token set object but the metadata could not be read since the XDB default tablespace was offline. By dropping the tablespace, some data may be lost.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Bring XDB default tablespace online.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19066: XML EXCHANGE is not enabled between the two tables.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The two tables specified in the EXCHANGE had different XML token sets. By exchanging partitions, some data might get corrupted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable XML EXCHANGE between the tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19067: Unable to create binary granular token on user default tablespace.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user default tablespace was full.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the size of the user default tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19068: Disabling XML EXCHANGE creates token tables in the SYSTEM tablespace.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either the table was in SYSTEM tablespace or it was partitioned and the default tablespace was SYSTEM. Granular token tables are forbidden on SYSTEM tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Move the table to a different tablespace or change the default tablespace if the table is partitioned.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19069: Table is already exchanging XML with itself.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An XML exchange was performed with the same table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not enable XML exchange with the same table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19070: cannot enable XML EXCHANGE in this type of table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0XML EXCHANGE was not allowed in global temporary tables or external tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use a global temporary table or external table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19071: Table does not have an XMLType stored as BINARY XML.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table was not an XMLTable or did not have an XMLType column stored as BINARY XML.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an XMLType or XMLTable stored as BINARY XML.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19072: Only STORE AS CLOB is supported with XMLType on the sharded table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0STORE AS CLOB was not specified with XMLType on the sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the STORE AS CLOB clause in the query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19073: unsupported column type for granular token set enabled table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to add or modify a column with an unsupported type for a granular token set enabled table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use user-defined Abstract Data Types (ADTs) or an ANYDATA column with granular token sets.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19074: Table does not have a granular token set.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table was not used with a granular token set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an XMLType stored as BINARY XML with a granular token set.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19075: Failed to move the token table indexes. Run dbms_csx_admin.RebuildTokenTablesIndexes before using the table.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to move the indexes to the given tablespace failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Run dbms_csx_admin.RebuildTokenTablesIndexes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19076: cannot move the XML token set to tablespace where the table owner does not have privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table owner did not have privileges in the given tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a tablespace where the table owner has privileges.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19100: PASSING or RETURNING keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword PASSING or RETURNING was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the PASSING or RETURNING keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19101: CONTENT keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword CONTENT was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the CONTENT keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19102: XQuery string literal expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The string literal containing the XQuery expression was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the XQuery expression as a string literal.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19103: VALUE keyword keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword VALUE was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the VALUE keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19104: invalid XQueryX: missing attribute\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XQueryX expression was not assigned the expected attribute.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid XQueryX.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19105: invalid XQueryX: expected text node – got\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XQueryX expression did not contain a text node as expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid XQueryX.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19106: invalid XQueryX: expected\u00a0string<\/i>\u00a0– got\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XQueryX expression did not contain the node as expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid XQueryX.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19107: invalid XQueryX – unsupported construct –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given XQuery expression contains an unsupported construct.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid XQueryX.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19108: WHITESPACE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword WHITESPACE was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the WHITESPACE keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19109: RETURNING keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword RETURNING was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the RETURNING keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19110: unsupported XQuery expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The program specified an XQuery expression that is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the XQuery with a expression that is supported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19111: error during evaluation of the XQuery expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19112: error raised during evaluation:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The error function was called during evaluation of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19113: trace function called during evaluation:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The trace function was called during evaluation of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the log file for the trace message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19114: XPST0003 – error during parsing the XQuery expression:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the parsing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19115: too many context items specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one context item was specified as input to the XMLQuery function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a single context item for the XMLQuery function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19116: too many xmlspace declarations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query prolog contained multiple xmlspace declarations.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate xmlspace declarations.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19117: XQST0070 – invalid redefinition of predefined namespace prefix ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given predefined namespace was being redefined in a namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the namespace declaration that redefines the predefined namespace prefix.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19118: XQST0066 – duplicate default namespace definition –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one default namespace declaration used the given namespace URI.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate default namespace definition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19121: duplicate attribute definition –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one attribute with the same name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate attribute definition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19122: unsupported XQuery declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The program specified an XQuery declaration that is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the XQuery with a declaration that is supported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19123: FORG0003: fn:zero-or-one() called with a sequence containing more than one item<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0sequence with more than one item was passed into fn:zero-or-one() function<\/span><\/span><\/p>\n

Action:<\/b>\u00a0correct input argument to fn:zero-or-one() function<\/span><\/span><\/p>\n

\n
<\/a> ORA-19124: FORG0004: fn:one-or-more() called with a sequence containing no items<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0sequence containing no items was passed into fn:one-or-more() function<\/span><\/span><\/p>\n

Action:<\/b>\u00a0correct input argument to fn:one-or-more() function<\/span><\/span><\/p>\n

\n
<\/a> ORA-19125: FORG0005: fn:exactly-one() called with a sequence containing zero or more than one item<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0sequence containing zero or more than one item was passed into fn:exactly-one() function<\/span><\/span><\/p>\n

Action:<\/b>\u00a0correct input argument to fn:exactly-one() function<\/span><\/span><\/p>\n

\n
<\/a> ORA-19126: XQuery extension expression contains neither a pragma that is recognized by the implementation nor an expression enclosed in curly braces<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No expression was enclosed in curly braces for the extension expression or the pragma content was not recognized.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct inputs to extension expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19127: XQST0067: XQST0067: A static error is raised if a Prolog contains more than one construction declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19128: XQST0068: A static error is raised if a Prolog contains more than one boundary-space declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19129: XQST0069: A static error is raised if a Prolog contains more than one empty order declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19130: XQST0070: A static error is raised if the predefined namespace prefix xml or xmlns is redeclared by a namespace declaration or namespace declaration attribute<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19131: XQST0071: A static error is raised if the namespace declaration attributes of a direct element constructor do not have distinct names<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19132: XQDY0072: It is a dynamic error if the result of the content expression of a computed comment constructor contains two adjacent hyphens or ends with a hyphen<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19133: XQST0073: It is a static error if the graph of module imports contains a cycle (that is, if there exists a sequence of modules M1 … Mn such that each Mi imports Mi+1 and Mn imports M1), unless all the modules in the cycle share a common namespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19134: XQDY0074: It is a dynamic error if the value of the name expression in a computed element constructor cannot be converted to an expanded QName (for example, because it contains a namespace prefix not found in statically known namespaces.)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19135: XQST0075: An implementation that does not support the Validation Feature must raise a static error if it encounters a validate expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19136: XQST0076: It is a static error if a collation subclause in an order by clause of a FLWOR expression does not identify a collation that is present in statically known collations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19137: XQST0079: It is a static error if an extension expression contains neither a pragma that is recognized by the implementation nor an expression enclosed in curly braces<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19138: The target type of a cast or castable expression must be an atomic type that is in the in-scope schema types and is not xs:NOTATION or xs:anyAtomicType, optionally followed by the occurrence indicator “?”; otherwise a static error is raised<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19139: XPST0081: It is a static error if a QName used in a query contains a namespace prefix that cannot be expanded into a namespace URI by using the statically known namespaces<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19140: XPST0083: It is a static error if the target type of a cast expression or constructor function is xs:QName or a type derived from xs:QName or xs:NOTATION, and the argument of the cast expression or constructor function is not a string literal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19141: XQDY0084: It is a dynamic error if the element validated by a validate statement does not have a top-level element declaration in the in-scope element declarations, if validation mode is strict<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19142: FONC0001 = FONC0001: undefined context item<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19143: XQTY0086: It is a type error if the typed value of a copied element or attribute node is namespace-sensitive when construction mode is preserve and copy-namespaces mode is no-preserve<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19145: XQST0087: It is a static error if the encoding specified in a Version Declaration does not conform to the definition of EncName specified in [XML 1.0]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19146: XQST0088: It is a static error if the literal that specifies the target namespace in a module import or a module declaration is of zero length<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19147: XQST0089: It is a static error if a variable bound in a for clause of a FLWOR expression, and its associated positional variable, do not have distinct names (expanded QNames)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19148: XQST0090: It is a static error if a character reference does not identify a valid character in the version of XML that is in use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19149: XQDY0091: An implementation may raise a dynamic error if an xml:id error, as defined in [XML ID], is encountered during construction of an attribute named xml:id<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19150: XQDY0092: An implementation may raise a dynamic error if a constructed attribute named xml:space has a value other than preserve or default<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19151: XQST0093: It is a static error to import a module M1 if there exists a sequence of modules M1 … Mi … M1 such that each module directly depends on the next module in the sequence (informally, if M1 depends on itself through some chain of module dependencies.)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19152: FOCH0001 = FOCH0001: codepoint not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19153: FOCH0002: unsupported collation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19154: FOCH0003: unsupported normalization form<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19155: FOCH0004: collation does not support collation units<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19156: FODC0001: no context document<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19157: FODC0002: error retrieving resource<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19158: FODC0004: invalid argument to fn:collection()<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19159: FODC0005: invalid argument to fn:doc<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19160: XPST0003 – syntax error: invalid variable name\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given XQuery variable does not begin with the ‘$’ sign<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the variable name to start with the “$” sign.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19161: XPTY0004 – XQuery type mismatch: invalid argument type ‘string<\/i>‘ for function ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type of the argument that was passed to the given function was not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the argument to be of a type supported by the given function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19162: XPTY0004 – XQuery type mismatch: invalid argument types ‘string<\/i>‘, ‘string<\/i>‘ for function ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type of the arguments that were passed to the given function was not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the arguments to be of a type appropriate for the given function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19163: XPTY0004 – XQuery type mismatch: argument type mismatch: expected – ‘string<\/i>‘ got – ‘string<\/i>‘ for function ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type of the arguments that were passed to the given function was not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the arguments to be of a type appropriate for the given function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19164: XQST0085 – It is a static error if the namespace URI in a namespace declaration attribute is a zero-length string, and the implementation does not support [XML Names 1.1].<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19165: FONS0003: no prefix defined for namespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19166: FONS0003: FONS0004: no namespace found for prefix<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19167: FONS0005: base uri not defined in the static context<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19168: FORG0002: invalid argument to fn:resolve-uri()<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19169: FORG0006: invalid argument type in ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a zero-length URI in namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19171: FORG0007: invalid argument to aggregate function<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19172: FORG0008: both arguments to fn:dateTime have a specified timezone<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19173: FORG0009: error in resolving a relative URI against a base URI in fn:resolve-uri<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19174: FORX0001: invalid regular expression flags<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19175: FORX0002: invalid regular expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19176: FORX0003: regular expression matches zero-length string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19177: FORX0004: invalid replacement string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19178: FOTY0001: type error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19179: FOTY0011: Type error. Context item is not a node<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19180: FOTY0012: argument node does not have a typed value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19181: FOTY0014: type exception<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19182: FORT0001: invalid number of parameters<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19183: FOTY0002: type definition not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19184: FOTY0021: invalid node type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19185: FOAR0002: numeric operation overflow\/unflow<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19186: FOCA0001: input value too large for decimal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19187: FOCA0002: invalid lexical value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19188: FOCA0003: input value too large for integer<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19189: FOCA0005: NaN supplied as float\/double value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19190: FOER0000: Unidentified error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19191: FOAR0001: division by zero<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19192: XQST0047: It is a static error if multiple module imports in the same Prolog specify the same target namespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19193: XQST0045: It is a static error if the function name in a function declaration is in one of the following namespaces: http:\/\/www.w3.org\/XML\/1998\/namespace, http:\/\/www.w3.org\/2001\/XMLSchema, http:\/\/www.w3.org\/2001\/XMLSchema-instance, http:\/\/www.w3.org\/2005\/04\/xpath-functions, http:\/\/www.w3.org\/2005\/04\/xpath-datatypes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19194: XQDY0026: It is a dynamic error if the result of the content expression of a computed processing instruction constructor contains the string “?>”<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during the processing of the XQuery expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the detailed error message for the possible causes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19195: Invalid policy in ora:contains<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid policy was specified in ora:contains.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename the policy name, policy schema name, or do not specify any policy to pick up default policy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19196: XMLType table or view is not allowed with this form of fn:collection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table or view specified in fn:collection was of XMLType.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0XMLType table or view is not allowed in the form of fn:collection(‘oradb:\/schema\/table\/ROW\/column’). It has to be a relational table or view.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19197: Column not found or invalid column type with this form of fn:collection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column to be retrieved was not found or was not of XMLType.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The column to be retrieved in the form of fn:collection(‘oradb:\/schema\/table\/ROW\/column’) or fn:collection(‘oradb:\/schema\/table\/ROW[predicate]\/column’) has to be of XMLType.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19198: Column not found or invalid column specified in the predicate with this form of fn:collection<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column specified in the predicate was not found or was not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The column specified in the predicate in the form of fn:collection(‘oradb:\/schema\/table\/ROW[predicate]\/column’) cannot be of XMLType.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19199: too many levels of nesting<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An XQuery expression contained too many levels of nesting parentheses.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the level of nesting parentheses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19200: Invalid column specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0All input arguments must be valid columns<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid list of columns<\/span><\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200 ORA-19000: missing RELATIONAL keyword Cause:\u00a0The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification. Action:\u00a0Supply the RELATIONAL keyword in the storage clause ORA-19001: Invalid storage option specified Cause:\u00a0An invalid storage option was specified for the XMLType. Action:\u00a0Supply…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2268","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-AA","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2268"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions"}],"predecessor-version":[{"id":2269,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions\/2269"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2268"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}