LISTE CODE ERREURS ORA ORACLE.

 

ORA-19100	ORA-19100: PASSING or RETURNING keyword expected
Cause	The keyword PASSING or RETURNING was missing.
Action	Specify the PASSING or RETURNING keyword.

 

ORA-19101	ORA-19101: CONTENT keyword expected
Cause	The keyword CONTENT was missing.
Action	Specify the CONTENT keyword.

 

ORA-19102	ORA-19102: XQuery string literal expected
Cause	The string literal containing the XQuery expression was missing.
Action	Specify the XQuery expression as a string literal.

 

ORA-19103	ORA-19103: VALUE keyword keyword
Cause	The keyword VALUE was missing.
Action	Specify the VALUE keyword.

 

ORA-19104	ORA-19104: invalid XQueryX: missing attribute string
Cause	The XQueryX expression was not assigned the expected attribute.
Action	Specify a valid XQueryX.

 

ORA-19105	ORA-19105: invalid XQueryX: expected text node - got string
Cause	The XQueryX expression did not contain a text node as expected.
Action	Specify a valid XQueryX.

 

ORA-19106	ORA-19106: invalid XQueryX: expected string - got string
Cause	The XQueryX expression did not contain the node as expected.
Action	Specify a valid XQueryX.

 

ORA-19107	ORA-19107: invalid XQueryX - unsupported construct - string
Cause	The given XQuery expression contains an unsupported construct.
Action	Specify a valid XQueryX.

 

ORA-19108	ORA-19108: WHITESPACE keyword expected
Cause	The keyword WHITESPACE was missing.
Action	Specify the WHITESPACE keyword.

 

ORA-19109	ORA-19109: RETURNING keyword expected
Cause	The keyword RETURNING was missing.
Action	Specify the RETURNING keyword.

 

ORA-19110	ORA-19110: unsupported XQuery expression
Cause	The program specified an XQuery expression that is not supported.
Action	Rewrite the XQuery with a expression that is supported.

 

ORA-19111	ORA-19111: error during evaluation of the XQuery expression
Cause	An error occurred during the processing of the XQuery expression.
Action	Check the detailed error message for the possible causes.

 

ORA-19112	ORA-19112: error raised during evaluation: string
Cause	The error function was called during evaluation of the XQuery expression.
Action	Check the detailed error message for the possible causes.

 

ORA-19113	ORA-19113: trace function called during evaluation: string
Cause	The trace function was called during evaluation of the XQuery expression.
Action	Check the log file for the trace message.

 

ORA-19114	ORA-19114: error during parsing the XQuery expression: string
Cause	An error occurred during the parsing of the XQuery expression.
Action	Check the detailed error message for the possible causes.

 

ORA-19115	ORA-19115: too many context items specified
Cause	More than one context item was specified as input to the XMLQuery function.
Action	Specify a single context item for the XMLQuery function.

 

ORA-19116	ORA-19116: too many xmlspace declarations
Cause	The query prolog contained multiple xmlspace declarations.
Action	Remove the duplicate xmlspace declarations.

 

ORA-19117	ORA-19117: invalid redefinition of predefined namespace prefix "string"
Cause	The given predefined namespace was being redefined in a namespace declaration.
Action	Remove the namespace declaration that redefines the predefined namespace prefix.

 

ORA-19118	ORA-19118: duplicate default namespace definition - string
Cause	More than one default namespace declaration used the given namespace URI.
Action	Remove the duplicate default namespace definition.

 

ORA-19121	ORA-19121: duplicate attribute definition - string
Cause	More than one attribute with the same name.
Action	Remove the duplicate attribute definition.

 

ORA-19122	ORA-19122: unsupported XQuery declaration
Cause	The program specified an XQuery declaration that is not supported.
Action	Rewrite the XQuery with a declaration that is supported.

 

ORA-19123	ORA-19123: fn:zero-or-one() called with a sequence containing more than one item
Cause	sequence with more than one item was passed into fn:zero-or-one() function
Action	correct input argument to fn:zero-or-one() function

 

ORA-19124	ORA-19124: fn:one-or-more() called with a sequence containing no items
Cause	sequence containing no items was passed into fn:one-or-more() function
Action	correct input argument to fn:one-or-more() function

 

ORA-19125	ORA-19125: fn:exactly-one() called with a sequence containing zero or more than one item
Cause	sequence containing zero or more than one item was passed into fn:exactly-one() function
Action	correct input argument to fn:exactly-one() function

 

ORA-19160	ORA-19160: XP0003 - syntax error: invalid variable name string
Cause	The given XQuery variable does not begin with the "$" sign
Action	Fix the variable name to start with the "$" sign.

 

ORA-19161	ORA-19161: XP0004 - XQuery type mismatch: invalid argument type "string" for function "string"
Cause	The type of the argument that was passed to the given function was not valid.
Action	Fix the argument to be of a type supported by the given function.

 

ORA-19162	ORA-19162: XP0004 - XQuery type mismatch: invalid argument types "string", "string" for function "string"
Cause	The type of the arguments that were passed to the given function was not valid.
Action	Fix the arguments to be of a type appropriate for the given function.

 

ORA-19163	ORA-19163: XP0004 - XQuery type mismatch: argument type mismatch: expected - "string" got - "string" for function "string"
Cause	The type of the arguments that were passed to the given function was not valid.
Action	Fix the arguments to be of a type appropriate for the given function.

 

ORA-19200	ORA-19200: Invalid column specification
Cause	All input arguments must be valid columns
Action	Specify a valid list of columns

 

ORA-19201	ORA-19201: Datatype not supported
Cause	The particular datatype is not supported in the XMLGEN operator
Action	Specify only supported datatypes as arguments to the XMLGEN operator

 

ORA-19202	ORA-19202: Error occurred in XML processingstring
Cause	An error occurred when processing the XML function
Action	Check the given error message and fix the appropriate problem

 

ORA-19203	ORA-19203: Error occurred in DBMS_XMLGEN processingstring
Cause	An error occurred when processing the DBMS_XMLGEN functions
Action	Check the given error message and fix the appropriate problem

 

ORA-19204	ORA-19204: Non-scalar value "string" is marked as XML attribute
Cause	Only 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 "@"
Action	Remove the "@" sign, or make the value a scalar.

 

ORA-19205	ORA-19205: Attribute "string" qualifies a non-scalar value in the select list
Cause	The attribute immediately follows a value of object or collection type in the select list or type definition.
Action	Remove the "@" sign, or make the previous value a scalar.

 

ORA-19206	ORA-19206: Invalid value for query or REF CURSOR parameter
Cause	The queryString argument passed to DBMS_XMLGEN.newContext was not a valid query, or REF CURSOR.
Action	Rewrite the query so that the queryString argument is a valid query or REF CURSOR.

 

ORA-19207	ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.
Cause	The scalar parameter to XMLELEMENT has been qualified with an alias.
Action	Remove the AS clause of the scalar element.

 

ORA-19208	ORA-19208: parameter string of function string must be aliased
Cause	The indicated parameter of the XML generation function has not been aliased, although it is an expression.
Action	Specify an alias for the expression using the AS clause.

 

ORA-19209	ORA-19209: invalid or unsupported formatting argument
Cause	An invalid or unsupported formatting argument was supplied
Action	Change the formatting argument to legal supported values

 

ORA-19210	ORA-19210: column "string", specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table "string"
Cause	The column specified using setKeyColumn()/setUpdateColumn() did not exist in the table.
Action	Change the column specified to be a column in the table

 

ORA-19211	ORA-19211: column "string", specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
Cause	The column specified using setKeyColumn() was a non-scalar type column.
Action	Change the column specified to be a scalar column in the table

 

ORA-19212	ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()
Cause	No columns were specified as key columns before the call to DBMS_XMLSTORE.updateXML.
Action	Use DBMS_XMLSTORE.setKeyColumn() to specify key columns

 

ORA-19221	ORA-19221: XP0001 - XQuery static context component string not initialized
Cause	An unitialized static context component was encountered during the static analysis of the expression.
Action	initialize the given static context.

 

ORA-19222	ORA-19222: XP0002 - XQuery dynamic context component string not initialized
Cause	An unitialized dynamic context component was encountered during the evaluation of the expression.
Action	Initialize the particular dynamic context component.

 

ORA-19223	ORA-19223: XP0003 - syntax error in XQuery expression
Cause	The given XQuery expression contains syntax errors.
Action	Fix the syntax error in the XQuery expression.

 

ORA-19224	ORA-19224: XP0004 - XQuery static type mismatch: expected - string got - string
Cause	The expression could not be used because it"s static type is not appropriate for the context in which it was used.
Action	Fix the expression to be of the required type or add appropriate cast functions around the expression.

 

ORA-19225	ORA-19225: XP0005 - XQuery static type error: expected non empty type got empty sequence
Cause	The static type assigned to an expression other than the () expression must not be the empty type.
Action	Fix the expression so it does not return empty sequences.

 

ORA-19226	ORA-19226: XP0006 - XQuery dynamic type mismatch: expected string got string
Cause	The expression could not be used because it"s dynamic type did not match the required type as specified by XQuery sequencetype matching rules.
Action	Fix the expression to return the expected type or use appropriate cast functions.

 

ORA-19227	ORA-19227: XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
Cause	The input node for atomization contained a type annotation that denoted a complex type with non-mixed complex content.
Action	Fix the input expression to fn:data to be a node that does not contain non-mixed complex content.

 

ORA-19228	ORA-19228: XP0008 - undeclared identifier: prefix "string" local-name "string"
Cause	The given identifier refers to either a type name, function name, namespace prefix, or variable name that is not defined in the static context.
Action	Fix the expression to remove the identifier, or declare the appropriate variable, type, function or namespace.

 

ORA-19229	ORA-19229: XP0009 - schema import not supported
Cause	A schema import was encountered in the query.
Action	remove the schema import.

 

ORA-19230	ORA-19230: XP0010 - unsupported axis string
Cause	An unsupported axis was encountered in the given expression.
Action	Remove the unsupported axis from the expression.

 

ORA-19232	ORA-19232: XQ0012 - imported schemas violate validity rules
Cause	The imported schemas did not satisfy the conditions for schema validity specified in the XMLSchema specification.
Action	Fix 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.

 

ORA-19233	ORA-19233: XQ0013 - invalid pragma
Cause	A pragma was specified whose contents are invalid.
Action	Specify the pragma with the correct contents.

 

ORA-19234	ORA-19234: XQ0014 - invalid or unsupported must-understand extension
Cause	The must-understand extension specified was either invalid or unsupported.
Action	remove the unsupported must-understand extension or fix the error.

 

ORA-19235	ORA-19235: XQ0015 - unsupported must-understand extension
Cause	The XQuery flagger was enabled and the query contained a must-understand extension.
Action	remove the unsupported must-understand extension.

 

ORA-19236	ORA-19236: XQ0016 - module declaration or import not supported
Cause	The given query had a module declaration or module import.
Action	Remove the import module or module declaration.

 

ORA-19237	ORA-19237: XP0017 - unable to resolve call to function - string:string
Cause	The name and arity of the function call given could not be matched with any in-scope function in the static context.
Action	Fix the name of the function or the number of parameters to match the list of in-scope functions.

 

ORA-19238	ORA-19238: XP0018 - focus not defined
Cause	The expression relied on the focus (context item, position and size) which was not defined.
Action	Define the focus for the expression.

 

ORA-19239	ORA-19239: XP0019 - step expression must return sequence of nodes
Cause	The step expression returned a sequence containing an atomic value.
Action	Fix the path expression to return only nodes.

 

ORA-19240	ORA-19240: XP0020 - context item must be node in an axis expression
Cause	The context item that was used in the axis epression is not a node.
Action	Change the context item to be a node.

 

ORA-19241	ORA-19241: XP0021 - cast to type string failed
Cause	The value inside a cast expression could not be cast to the required type.
Action	Fix the input to the cast expression to be of a castable type.

 

ORA-19242	ORA-19242: XQ0022 - namespace declaration attribute must be a literal
Cause	The namespace declaration attribute was not a literal string.
Action	Fix the namespace declaration to be a literal string.

 

ORA-19243	ORA-19243: XQ0023 - invalid document node content in element constructor
Cause	The content sequence in an element constructor contained a document node.
Action	Change the content of the element constructor so that it does not contain a document node.

 

ORA-19244	ORA-19244: XQ0024 - invalid attribute node in element constructor
Cause	The content sequence in an element constructor contained an attribute node following a node that was not an attribute node.
Action	Change the content sequence of the element constructor so that it does not contain the attribute node.

 

ORA-19245	ORA-19245: XQ0025 - duplicate attribute name string
Cause	The content sequence of the element constructor contained more than one attribute that had the same name.
Action	Remove the duplicate attributes.

 

ORA-19246	ORA-19246: XQ0026 - validation failed - element string not found in in-scope element declarations
Cause	The validation mode was strict and the element-constructor contained an element name that was not present in the in-scope element declarations.
Action	Fix the validation mode to be lax or import the schema definition that contains the required element declaration.

 

ORA-19247	ORA-19247: XQ0027 - validation error
Cause	An error was encountered during the validation of the expression.
Action	Fix the validation error.

 

ORA-19248	ORA-19248: XQ0028 - invalid node in document constructor
Cause	The content sequence in a document constructor contained either a document or an attribute node.
Action	Fix the content so it does not contain any of the above node types.

 

ORA-19249	ORA-19249: XP0029 - value does not match facet of the target type
Cause	The input value to a cast expression did not satisfy the facets of the target type.
Action	Fix the value to conform to the facets of the target type.