Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /

 

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.

 

Haut de Page www.dba-ora.fr

Partager cette page

Repost 0
Published by