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

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

\n
ORA-19200: Invalid column specification<\/i><\/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

\n
<\/a> ORA-19201: Datatype not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The particular datatype is not supported in the XMLGEN operator<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only supported datatypes as arguments to the XMLGEN operator<\/span><\/span><\/p>\n

\n
<\/a> ORA-19202: Error occurred in XML processingstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when processing the XML function<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the given error message and fix the appropriate problem<\/span><\/span><\/p>\n

\n
<\/a> ORA-19203: Error occurred in DBMS_XMLGEN processingstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when processing the DBMS_XMLGEN functions<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the given error message and fix the appropriate problem<\/span><\/span><\/p>\n

\n
<\/a> ORA-19204: Non-scalar value ‘string<\/i>‘ is marked as XML attribute<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Only scalar values (i.e. values which are not of object or collection type) can be marked as XML attribute,i.e. is prefixed by ‘@’. In this case, a non-scalar value was prefixed with ‘@’<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the ‘@’ sign, or make the value a scalar.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19205: Attribute ‘string<\/i>‘ qualifies a non-scalar value in the select list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute immediately follows a value of object or collection type in the select list or type definition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the ‘@’ sign, or make the previous value a scalar.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-19206: Invalid value for query or REF CURSOR parameter<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The queryString argument passed to DBMS_XMLGEN.newContext was not a valid query, or REF CURSOR.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that the queryString argument is a valid query or REF CURSOR.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19207: scalar parameter\u00a0string<\/i>\u00a0of XMLELEMENT cannot have an alias.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The scalar parameter to XMLELEMENT has been qualified with an alias.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the AS clause of the scalar element.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19208: parameter\u00a0string<\/i>\u00a0of function\u00a0string<\/i>\u00a0must be aliased<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The indicated parameter of the XML generation function has not been aliased, although it is an expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify an alias for the expression using the AS clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19209: invalid or unsupported formatting argument<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid or unsupported formatting argument was supplied<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the formatting argument to legal supported values<\/span><\/span><\/p>\n

\n
<\/a> ORA-19210: column ‘string<\/i>‘, specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column specified using setKeyColumn()\/setUpdateColumn() did not exist in the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the column specified to be a column in the table<\/span><\/span><\/p>\n

\n
<\/a> ORA-19211: column ‘string<\/i>‘, specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column specified using setKeyColumn() was a non-scalar type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the column specified to be a scalar column in the table<\/span><\/span><\/p>\n

\n
<\/a> ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No columns were specified as key columns before the call to DBMS_XMLSTORE.updateXML.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use DBMS_XMLSTORE.setKeyColumn() to specify key columns<\/span><\/span><\/p>\n

\n
<\/a> ORA-19213: error occurred in XML processing at linesstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when processing the given lines in an XML function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the given error message and fix the appropriate problem.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19221: XPST0001 – XQuery static context component\u00a0string<\/i>\u00a0not initialized<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unitialized static context component was encountered during the static analysis of the expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0initialize the given static context.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19222: XPDY0002 – XQuery dynamic context component\u00a0string<\/i>\u00a0not initialized<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unitialized dynamic context component was encountered during the evaluation of the expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Initialize the particular dynamic context component.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19223: XPST0003 – syntax error in XQuery expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given XQuery expression contains syntax errors.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the syntax error in the XQuery expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19224: XPTY0004 – XQuery static type mismatch: expected –\u00a0string<\/i>\u00a0got –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The expression could not be used because it’s static type is not appropriate for the context in which it was used.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the expression to be of the required type or add appropriate cast functions around the expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19225: XPST0005 – XQuery static type error: expected non empty type got empty sequence<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The static type assigned to an expression other than the () expression must not be the empty type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the expression so it does not return empty sequences.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19226: XPTY0006 – XQuery dynamic type mismatch: expected\u00a0string<\/i>\u00a0got\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The expression could not be used because it’s dynamic type did not match the required type as specified by XQuery sequencetype matching rules.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the expression to return the expected type or use appropriate cast functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19227: XPTY0007 – fn:data function is applied to a node (type (string<\/i>)) whose type annotation denotes a complex type with non-mixed complex content.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input node for atomization contained a type annotation that denoted a complex type with non-mixed complex content.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the input expression to fn:data to be a node that does not contain non-mixed complex content.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19228: XPST0008 – undeclared identifier: prefix ‘string<\/i>‘ local-name ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given identifier refers to either a type name, function name, namespace prefix, or variable name that is not defined in the static context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the expression to remove the identifier, or declare the appropriate variable, type, function or namespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19229: XQST0009 – schema import not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A schema import was encountered in the query.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove the schema import.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19230: XPST0010 – unsupported axis\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unsupported axis was encountered in the given expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the unsupported axis from the expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19231: XPST0011 –<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-19232: XQST0012 – imported schemas violate validity rules<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The imported schemas did not satisfy the conditions for schema validity specified in the XMLSchema specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the imported schemas to satisfy the validity rules.In particular, the definitions must be valid, complete, and unique — that is, the pool of definitions must not contain two or more schema components with the same name and target namespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19233: XQST0013 – invalid pragma<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A pragma was specified whose contents are invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the pragma with the correct contents.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19234: XQST0014 – invalid or unsupported must-understand extension<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The must-understand extension specified was either invalid or unsupported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove the unsupported must-understand extension or fix the error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19235: XQST0015 – unsupported must-understand extension<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XQuery flagger was enabled and the query contained a must-understand extension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove the unsupported must-understand extension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19236: XQST0016 – module declaration or import not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given query had a module declaration or module import.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the import module or module declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19237: XPST0017 – unable to resolve call to function –\u00a0string<\/i>:string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name and arity of the function call given could not be matched with any in-scope function in the static context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the name of the function or the number of parameters to match the list of in-scope functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19238: XPTY0018 – It is a type error if the result of the last step in a path expression contains both nodes and atomic values<\/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-19239: XPTY0019 – It is a type error if the result of an step (other than the last step) in a path expression contains an atomic value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The step expression returned a sequence containing an atomic value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the path expression to return only nodes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19240: XPTY0020 – context item must be node in an axis expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The context item that was used in the axis epression is not a node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the context item to be a node.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19241: XPDY0021 – cast to type\u00a0string<\/i>\u00a0failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value inside a cast expression could not be cast to the required type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the input to the cast expression to be of a castable type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19242: XQST0022 – namespace declaration attribute must be a literal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The namespace declaration attribute was not a literal string.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration to be a literal string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19243: XQTY0023 – invalid document node content in element constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content sequence in an element constructor contained a document node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the content of the element constructor so that it does not contain a document node.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19244: XQTY0024 – invalid attribute node in element constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content sequence in an element constructor contained an attribute node following a node that was not an attribute node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the content sequence of the element constructor so that it does not contain the attribute node.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19245: XQDY0025 – duplicate attribute name\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content sequence of the element constructor contained more than one attribute that had the same name.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-19246: validation failed – element\u00a0string<\/i>\u00a0not found in in-scope element declarations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The validation mode was strict and the element-constructor contained an element name that was not present in the in-scope element declarations.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the validation mode to be lax or import the schema definition that contains the required element declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19247: XQDY0027 – validation error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered during the validation of the expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the validation error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19248: XQTY0028 – invalid node in document constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content sequence in a document constructor contained either a document or an attribute node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the content so it does not contain any of the above node types.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19249: XQDY0029 – value does not match facet of the target type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input value to a cast expression did not satisfy the facets of the target type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the value to conform to the facets of the target type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19250: XQTY0030 – too many values to validate expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The argument of a validate expression returned more than one element or document node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the argument of the validate expression to return a single element or document node.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19251: XQST0031 – unsupported query version<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query version specified in the prolog was not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply the version of the query that is supported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19252: XQST0032 – too many declarations for base URI<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query prolog contained multiple declarations for the base URI.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate definitions for the base URI.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19253: XQST0033 – too many declarations for namespace prefix\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query prolog contained multiple declarations for the same namespace prefix.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate definitions for the namespace prefix.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19254: XQST0034 – too many declarations for function\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query module contained more than one function, either declared or imported, which have the same expanded QName.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate function definitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19255: XQST0035 – too many declarations of\u00a0string<\/i>\u00a0in imported schemas<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Two schemas were imported that defined the same name in the same symbol space and in the same scope.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the schema imports to remove the name conflict.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19256: XQST0036 – missing type definitions in imported module<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A module was imported, which contains references to type names that are not defined in the in-scope type definitions inside the module.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the module definintion to include the in-scope type definition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19257: XQST0037 – function or variable\u00a0string<\/i>\u00a0in module already defined<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A module being imported contained the function or variable that is already declared in the static context of the importing module.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-19258: XQST0038 – unsupported or duplicate default collation specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query prolog prolog either specified more than one default collation or the collation specified was not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the duplicate definition or specify a supported collation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19259: XQST0039 – duplicate parameter name\u00a0string<\/i>\u00a0in function declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The function declaration contained more than one parameter with the same name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the function declaration to remove the duplicate parameters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19260: XQST0040 – invalid namespace node in element constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content sequence in an element constructor contained a namespace node node following a node that was not a namespace node.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the namespace node in the element constructor.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19261: XQDY0041 – non empty URI in QName<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name expression in a computed processing instruction or computed namespace constructor returned a QName whose URI part was not empty.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the processing instruction or computed namespace constructor to return the QName with an empty URI part.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19262: XQST0042 – namespace constructor not inside an element constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The enclosing expression of a computed namespace constructor was not a computed element constructor.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace constructor to be inside an element constructor.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19263: XQST0043 – duplicate namespace prefix\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Two or more computed namespace constructors within the same computed element constructor attempted to bind the same namespace prefix.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-19264: XQDY0044 – invalid namespace in attribute constructors<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A computed attribute constructor returned a QName that is in the pre-defined XML namespace (corresponding to namespace prefix xmlns).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the namespace for the computed attribute constructor.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19265: XQST0045 – invalid or unknown prefix\u00a0string<\/i>\u00a0in function declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The declared function name in a function declaration had no namespace prefix or had one of the predefined namespace prefixes other than local.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the function declaration to have the correct prefix.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19266: XQST0046 – invalid URI<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given URI contained a lexical form that was not valid according to the definition of xs:anyURI in XML Schema.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-19267: module\u00a0string<\/i>\u00a0not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The module with the given target URI could not be found.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the prolog to import only available modules.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19268: XQST0048 – namespace\u00a0string<\/i>\u00a0does not match target namespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The module contained a function or variable whose namespace did not match the target namespace of the module.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace of the function or variable to match the target namespace of the module.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19269: XQST0049 – variable\u00a0string<\/i>\u00a0defined multiple times<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The module defined or imported the same variable multiple times.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the import or the module definition to remove duplicate definitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19270: XPDY0050 – treat failed – expected\u00a0string<\/i>\u00a0got\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type of the operand to the treat expression did not match the required type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the input operand to be of the correct type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19271: XPST0051 – invalid atomic type definition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The QName used as an AtomicType in a SequenceType was not defined in the in-scope type definitions as an atomic type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the correct atomic type name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19272: XQDY0052 – invalid atomic value in attribute or element constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The content of the element or attribute constructor included an atomic value that could not be cast into a string.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the content to contain atomic values that can be cast to a string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19273: XQST0053 – empty string in namespace declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An empty string was used in a namespace declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the namespace declaration to have a non-empty string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19274: XQST0054 – variable initialization failed due to circularity<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A circular definition was encountered when the variable was initialized.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the circularity in the initialization.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19275: XQST0055 – schema path\u00a0string<\/i>\u00a0not found in list of in-scope schema definitions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ElementTest specified a schema path that could not be found in the list of in-scope schema definitions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Include the appropriate schema that can be used to resolve the ElementTest.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19276: XPST0005 – XPath step specifies an invalid element\/attribute name: (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XPath step specified invalid element or attribute name that did not match any nodes according to the input XML schema or structure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the element or attribute name as the name may be mis-spelled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19277: XPST0005 – XPath step specifies an item type matching no node: (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XPath step specified an item type that did not match any nodes according to the input XML schema or structure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the item type defintion as node of such type does not exit in the input XML schema or structure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19278: Invalid value: (string<\/i>) for type: (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value was invalid for the type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the value or change the type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19279: XPTY0004 – XQuery dynamic type mismatch: expected singleton sequence – got multi-item sequence<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The XQuery sequence passed in had more than one item.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the XQuery expression to return a single item sequence.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19280: XQuery dynamic type mismatch: expected atomic value – got node<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A node was passed in to the expression where an atomic value was expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the XQuery expression to return an atomic value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19281: XQST0055 – It is a static error if a Prolog contains more than one copy-namespaces declaration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate copy-namespaces declarations.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19282: XQST0068 – It is a static error if a Prolog contains more than one xmlspace declaration<\/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-19283: XQST0031 – It is a static error if the version number specified in a version declaration is not supported by the implementation.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query contained a version declaration not supported by this implementation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the version declaration to 1.0 which is the version supported by this implementation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19284: Encoding specification in version declaration not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query contained an encoding specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the encoding specification.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The URI provided could not be resolved to a valid resource.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a valid URI for a resource.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19286: XPST0017 – unable to resolve call to function –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name and arity of the function call given could not be matched with any in-scope function in the static context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the name of the function or the number of parameters to match the list of in-scope functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19287: XPST0017 – invalid number of arguments to function –\u00a0string<\/i>:string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name and arity of the function call given could not be matched with any in-scope function in the static context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the name of the function or the number of parameters to match the list of in-scope functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19288: XPST0017 – invalid number of arguments to function –\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name and arity of the function call given could not be matched with any in-scope function in the static context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the name of the function or the number of parameters to match the list of in-scope functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19289: XQST0034 – function\u00a0string<\/i>:string<\/i>\u00a0declared or defined multiple times<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Multiple functions declared or imported by a module had the same expanded QName and the same number of arguments.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the function declaraction or definition to remove duplicates.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19290: XQST0069 – more than one empty order declaration declared in the prolog<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A prolog had more than one empty order declaration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the prolog to have just one empty order declaration.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19291: XPST0081 – specified QName cannot be expanded into a namespace URI<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The namespace prefix of the QName could not be expanded into a namespace URI by using the statically known namespaces.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a namespace prefix that can be resolved into a namespace URI from the statically known namespaces.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19292: XQST0057: It is a static error if a schema import binds a namespace prefix but does not specify a target namespace other than a 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-19293: XQST0058: It is a static error if multiple schema imports 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-19294: XQST0059: It is a static error if an implementation is unable to process a schema or module import by finding a schema or module with the specified 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-19295: XQST0060: It is a static error if the name of a function in a function declaration is not in a namespace (expanded QName has a null namespace 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-19296: XQDY0061: It is a dynamic error if the operand of a validate expression is a document node whose children do not consist of exactly one element node and zero or more comment and processing instruction nodes, in any order<\/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-19297: XQDY0064: It is a dynamic error if the value of the name expression in a computed processing instruction constructor is equal to “XML” (in any combination of upper and lower case<\/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-19298: XQST0065: A static error is raised if a Prolog contains more than one ordering mode 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-19299: XQST0066: A static error is raised if a Prolog contains more than one default element\/type namespace declaration, or more than one default function namespace 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-19300: Error occurred in uri processingstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when processing the URL<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the given error message and fix the appropriate problem<\/span><\/span><\/p>\n

\n
<\/a> ORA-19320: Host name not specified in HTTP URL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A host name was not specified in the HTTP url<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a host name in the HTTP url when creating the URL string<\/span><\/span><\/p>\n

\n
<\/a> ORA-19321: Could not open HTTP connection to host (string<\/i>): port (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A HTTP connection could not be opened to the host<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid host name and port to connect to<\/span><\/span><\/p>\n

\n
<\/a> ORA-19322: An error occurred while reading from host (string<\/i>): port (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while reading from the HTTP host<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid host name and port to read from<\/span><\/span><\/p>\n

\n
<\/a> ORA-19323: Invalid url string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The URL must be a valid URL string<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid url string<\/span><\/span><\/p>\n

\n
<\/a> ORA-19330: Type ‘string<\/i>‘.’string<\/i>‘ not installed. Please install the type before using the CREATE_DBURI operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type required for the CREATE_DBURI operator has not been installed correctly.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Read the installation notes to install the type correctly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19331: Last argument to CREATE_DBURI operator must be a column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The final argument to the CREATE_DBURI operator must be a column to which the reference is being created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid column name in the query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19332: Invalid column in the CREATE_DBURI operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The argument to the CREATE_DBURI operator can only be a column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid column name for the operator<\/span><\/span><\/p>\n

\n
<\/a> ORA-19333: Invalid flags for the CREATE_DBURI operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The flags argument given to the DBURI operator is invalid<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid flag value (TEXT) for the DBURI operator<\/span><\/span><\/p>\n

\n
<\/a> ORA-19334: Invalid column specification for CREATE_DBURI operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0All columns must be valid and pointing to the same table or view<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify valid list of columns that are from the same table or view.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19335: Invalid format type object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid format type object was specified for the XML function<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid format type object<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The XML being generated does not have an enclosing root element.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The XML generated must have a root element<\/span><\/span><\/p>\n

\n
<\/a> ORA-19361: ONLINE option not allowed with this type of index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ONLINE option was specified to validate the structure of a system-generated metadata index<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The ONLINE option can not be used with system-generated metadata indexes such as an LOB index, an IOT Top index, an Index on Clusters etc., Run query without using the ONLINE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19371: invalid update option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to call load_sqlset with an update option that is different than REPLACE and ACCUMULATE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Adjust the update option and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19372: invalid update condition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to call load_sqlset with an invalid update condition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the update condition (e.g., NEW.COL1_NAME >= OLD.COL2_NAME) and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19373: invalid staging table or tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to create a staging table and specified an invalid staging table (or one that already exists) or tablespace<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the arguments and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19374: invalid staging table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified an invalid staging table to one of the pack, unpack, or remap stgtab routines, or the user does not have the correct privileges on the staging table<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a correct staging table or grant the appropriate privileges<\/span><\/span><\/p>\n

\n
<\/a> ORA-19375: no CREATE TABLE privilege on schema “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user tried to create a staging table when he is missing the CREATE TABLE privilege on the specified schema.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the privilege to the user and retry<\/span><\/span><\/p>\n

\n
<\/a> ORA-19376: no privileges on tablespace provided or tablespace is offline<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user tried to create a staging table on a tablespace on which he does not have any space allocated, or it is offline<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Allocate space on the tablespace, bring it online, and retry<\/span><\/span><\/p>\n

\n
<\/a> ORA-19377: no “SQL Tuning Set” with name like “string<\/i>” exists for owner like “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified a filter to a pack\/unpack function for the SQL Tuning Set that targets no STS in the SYS schema or the staging table, respectively<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a different filter after checking the state of the system<\/span><\/span><\/p>\n

\n
<\/a> ORA-19378: invalid mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified an invalid mode argument to the capture function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a mode argument that was defined in the dbmssqlt file<\/span><\/span><\/p>\n

\n
<\/a> ORA-19379: invalid time_limit or repeat_interval<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a NULL value was specified for the time_limit or the repeat_interval value, or the repeat_interval value was greater than the time_limit value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a non-NULL value and ensure that time_limit value is greater than or equal to the repeat_interval value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19380: invalid plan filter<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user specified an invalid filter for the plan when calling the select_sqlset table function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Adjust the the filter to be one of the following values and retry the operation: MAX_ELAPSED_TIME, MAX_CPU_TIME, MAX_DISK_READS, MAX_OPTIMIZER_COST, MAX_BUFFER_GETS, FIRST_LOADED LAST_LOADED, FIRST_GENERATED, or LAST_GENERATED.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19381: cannot create staging table in SYS schema<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to create a staging table in the sys schema<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the table in another schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19384: cannot pack into staging table from previous version<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform a pack operation on a staging table from a previous version.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a staging table in the current version and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19385: staging table is empty<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform an operation on an empty staging table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the staging table to ensure that it has rows.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19386: target object already exists for tuning task “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to set a target object for a tuning task when one had already been set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a new task if another target object is needed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19387: “SQL Tuning Set” “string<\/i>” belongs to another tuning task<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to tune a task-managed SQL Tuning Set belonging to one task within the scope of another task.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the SQL Tuning Set and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19388: operation not supported for “SQL Tuning Set” type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attempted operation was unsupported for the type of the given SQL Tuning Set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the SQL Tuning Set and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19389: LOB types are not supported for SQL binds<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A LOB type was provided in a SQL bind list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Replace the LOB binds with legal bind types or try another SQL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19390: The profile type is not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The profile type is not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the available profile types.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19400: System type conflict with object SYS.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user had an object with the same name as one of the system types. The system types were not initialized properly.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the conflicting object and rerun migration.<\/span><\/span><\/p>\n

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19200 to ORA-19400 ORA-19200: Invalid column specification Cause:\u00a0All input arguments must be valid columns Action:\u00a0Specify a valid list of columns ORA-19201: Datatype not supported Cause:\u00a0The particular datatype is not supported in the XMLGEN operator Action:\u00a0Specify only supported datatypes as arguments to the XMLGEN operator ORA-19202: Error…<\/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-2270","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-AC","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2270","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=2270"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2270\/revisions"}],"predecessor-version":[{"id":2271,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2270\/revisions\/2271"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2270"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}