86 ORA-40001 to ORA-40556
- ORA-40001: value for <varname>string</varname> must be greater than zero
-
Cause: The input parameter in question has a value of zero or less.
- ORA-40002: wordsize must be <varname>string</varname> or greater
-
Cause: The input wordsize is less than the prescribed limit for the BLAST Match or Align algorithm.
- ORA-40003: wordsize must be in the range <varname>string</varname> - <varname>string</varname> for BLAST-P
-
Cause: The input wordsize has a value out of the prescribed range.
- ORA-40004: penalty must be negative for BLAST-N
-
Cause: The input value provided for penalty is zero or greater.
- ORA-40021: no column named <varname>string</varname> in training table <varname>string</varname>
-
Cause: The training table does not contain the specified column
- ORA-40022: null case ID column - cannot provide row diagnostics in <varname>string</varname>
-
Cause: A row diagnostics table name was provided, but without a corresponding case or row identifier column in the build data.
- ORA-40023: sufficient memory could not be allocated given the number of attributes
-
Cause: Unable to allocate sufficient memory to create a model capable of producing confidence bounds on predictions because there were too many attributes or there were high cardinality categorical attributes, or both, in the build data.
- ORA-40024: solution to least squares problem could not be found
-
Cause: Unable to find solution because the predictor covariance matrix was singular.
- ORA-40025: reference class name not found in build data
-
Cause: The provided reference class name was not found in the build data.
- ORA-40026: reference class name not found in the weights table
-
Cause: The provided reference class name did not correspond to any of the entries in the weights table.
- ORA-40027: Target attribute has more than two distinct values
-
Cause: Generalized Linear Models only support binary classification.
- ORA-40028: solution to least squares problem could not be found
-
Cause: Unable to find solution because the predictor build data were not properly scaled.
- ORA-40029: Specified diagnostics table name already exists
-
Cause: A diagnostics table name matching an existing table was specified.
- ORA-40030: solution to least squares problem could not be found
-
Cause: Unable to find solution because the predictor covariance matrix was singular for the forced-in features.
- ORA-40031: insufficient memory for model build given the number of forced-in features (maximum allowable for this data: <varname>string</varname>)
-
Cause: Unable to allocate sufficient memory to create a feature-selection model because there were too many forced-in features or the forced-in features were high cardinality categorical attributes, or both.
- ORA-40032: solution to least squares problem could not be found
-
Cause: Unable to find solution because the predictor covariance matrix was singular for the selected features.
- ORA-40101: Data Mining System Error <varname>string</varname>-<varname>string</varname>-<varname>string</varname>
-
Cause: An internal system error occured during a data mining operation.
- ORA-40102: invalid input <varname>string</varname> for data mining operation <varname>string</varname>
-
Cause: The input parameter is either null or invalid for the given operation.
- ORA-40103: invalid case-id column: <varname>string</varname>
-
Cause: The case-id column was invalid. If a case-id column is specified, it must be present in the input data source. The case-id column cannot be the same as the target column, and the column's data type is restricted to NUMBER, CHAR, and VARCHAR2 when building a GLM model with a diagnostics table.
- ORA-40104: invalid training data for model build
-
Cause: The training data provided in the reported table is unsuitable for build, either because it is empty, has unsuitable data, or the schema of the table does not match the input specifications.
- ORA-40105: input data incompatible with model signature
-
Cause: The data provided for this post-build operation is in format different from that used for model build.
- ORA-40106: positive target value not specified for computing Lift
-
Cause: Positive target value has not been specified for Lift.
- ORA-40107: operation requires <varname>string</varname> option to be installed
-
Cause: The specified option has not been installed with the RDBMS.
- ORA-40108: input data contains too few distinct target (<varname>string</varname>) values
-
Cause: At least two distinct target values are required for Build.
- ORA-40109: inconsistent logical data record
-
Cause: Repeated instances of a record identifier or repeated attribute(s) in a nested column.
- ORA-40110: Duplicate model tables found for table type <varname>string</varname>
-
Cause: Operation would result in duplicate model table types which is not supported.
- ORA-40111: no mining attributes found in build data
-
Cause: Could not build a model when only special or empty columns were present. Special columns include target, row weight, and case ID columns.
- ORA-40112: insufficient number of valid data rows
-
Cause: Fewer than two valid data rows were found in the build data.
- ORA-40113: insufficient number of distinct target values
-
Cause: Less than two distinct target values were found in the build data.
- ORA-40114: weights table target values mismatched with build data
-
Cause: The entries in the weights table did not correspond to the target values in the build data.
- ORA-40115: weights table schema is incorrect
-
Cause: The weights table did not have the required schema.
- ORA-40116: NULL values found in weights table
-
Cause: The weights table had NULL entries.
- ORA-40117: repeated target values found in weights table
-
Cause: The weights table had repeated target values.
- ORA-40118: insufficient number of target values in weights table
-
Cause: The weights table had less that 2 target values.
- ORA-40119: nested columns incompatible with missing value treatment
-
Cause: delete_row missing value treatment is not supported for nested columns.
- ORA-40120: invalid weight value in the weights table
-
Cause: Negative or zero weight values were found in the weights table.
- ORA-40121: force option not allowed for drop model in different schema
-
Cause: The force option was specified, but the model is in a different schema.
- ORA-40122: invalid data type for row weights column <varname>string</varname>.
-
Cause: Row weights column was not assigned one of the allowed data types.
- ORA-40123: invalid row weights column <varname>string</varname>
-
Cause: Row weights column was the same as the target column.
- ORA-40181: invalid transformation definition for column <varname>string</varname>
-
Cause: Transformation definition has duplicate or NULL columns.
- ORA-40182: invalid column reference
-
Cause: Transformation expression has no column references or more than one reference or the reference is qualified.
- ORA-40183: invalid stack definition for attribute <varname>string</varname>
-
Cause: Stack definition expression or reverse expression has syntax errors or it does not match the transformation definition.
- ORA-40184: transformation definition does not match the data
-
Cause: Transformation definition specifies nested transformation for non-nested data or it removes all of the columns.
- ORA-40201: invalid input parameter <varname>string</varname>
-
Cause: The input parameter was either null or invalid.
- ORA-40202: column <varname>string</varname> does not exist in the input table <varname>string</varname>
-
Cause: The column was missing from the table.
- ORA-40203: model <varname>string</varname> does not exist
-
Cause: The model did not exist.
- ORA-40204: model <varname>string</varname> already exists
-
Cause: A model by the same name exists.
- ORA-40205: invalid setting name <varname>string</varname>
-
Cause: The input setting name was invalid.
- ORA-40206: invalid setting value for setting name <varname>string</varname>
-
Cause: The input value for the given setting name was invalid.
- ORA-40207: duplicate or multiple function settings
-
Cause: The input settings table contained settings for multiple mining functions.
- ORA-40208: duplicate or multiple algorithm settings for function <varname>string</varname>
-
Cause: The input settings table had duplicate or multiple algorithm settings for a mining function.
- ORA-40209: setting <varname>string</varname> is invalid for <varname>string</varname> function
-
Cause: The specified setting was not supported for the mining function supplied.
- ORA-40210: invalid score criterion type when cost matrix is specified
-
Cause: The score criterion type may not be 'PROBABILITY' when a cost matrix is specified.
- ORA-40211: algorithm name <varname>string</varname> is invalid
-
Cause: Algorithm name for the model was invalid or the operation was not valid for the algorithm.
- ORA-40212: invalid target data type in input data for <varname>string</varname> function
-
Cause: Target data type was invalid.
- ORA-40213: contradictory values for settings: <varname>string</varname>, <varname>string</varname>
-
Cause: The settings values were not compatible.
- ORA-40214: duplicate setting: <varname>string</varname>
-
Cause: Duplicate setting in the settings table.
- ORA-40215: model <varname>string</varname> is incompatible with current operation
-
Cause: The current operation was not supported for the mining function the model corresponds to.
- ORA-40216: feature not supported
-
Cause: The feature was not supported in the API.
- ORA-40217: priors table mismatched with training data
-
Cause: The entries in the priors table do not correspond to the targets in the training data.
- ORA-40218: Both priors table and weights table are specified
-
Cause: Both a priors table and a weights table are specified for SVM model build.
- ORA-40219: apply result table <varname>string</varname> is incompatible with current operation
-
Cause: The current operation was not allowed for the apply result table supplied.
- ORA-40220: maximum number of attributes exceeded
-
Cause: The data had too many attributes.
- ORA-40221: maximum target cardinality exceeded
-
Cause: The target cardinality of the training data was too high.
- ORA-40222: data mining model export failed, job name=<varname>string</varname>, error=<varname>string</varname>
-
Cause: The model export job failed.
- ORA-40223: data mining model import failed, job name=<varname>string</varname>, error=<varname>string</varname>
-
Cause: The model import job failed.
- ORA-40224: transactional input - no matching id for value column <varname>string</varname>
-
Cause: The training data is transactional - and a value column is specified without a matching id specification.
- ORA-40225: model is currently in use by another process
-
Cause: The model is currently in use by another process.
- ORA-40226: model upgrade/downgrade must be performed by SYS
-
Cause: Upgrade/Downgrade routines are being invoked by a user with insufficient privilieges.
- ORA-40227: invalid transformation attribute
-
Cause: Transformation list provided to CREATE_MODEL has duplicate or NULL attributes. Case ID or target attribute has attribute_subname that is not NULL. Attribute provided to ALTER_REVERSE_EXPRESSION does not exist in the model.
- ORA-40228: scoring cost matrix already exists
-
Cause: The model already has a scoring cost matrix.
- ORA-40229: scoring cost matrix not found
-
Cause: The model does not have a scoring cost matrix.
- ORA-40230: invalid transformation expression
-
Cause: Expression has syntax or semantic errors.
- ORA-40231: transactional input incompatible with specified algorithm
-
Cause: Training data in transactional format is not accepted for model creation using the specified mining algorithm.
- ORA-40232: transactional input - incompatible datatype for column <varname>string</varname>
-
Cause: The data type of the column in the input training data is not supported.
- ORA-40233: transactional input - case id should be provided with id <varname>string</varname>
-
Cause: The training data is transactional by virtue of presence of a and item id - but does not have a case id specification.
- ORA-40234: reverse expression incompatible with model cost matrix
-
Cause: A cost matrix existed for this model with actual and predicted values which were inconsistent with the values resulting from the specified reverse transformation.
- ORA-40251: no support vectors were found
-
Cause: The input data is non-predictive in nature, or one of the input settings is incorrect/incompatible with respect to the input data.
- ORA-40252: no target values were found
-
Cause: No target values were identified during load.
- ORA-40253: no target counter examples were found
-
Cause: One or more of the target classes have only positive examples.
- ORA-40254: priors cannot be specified for one-class models
-
Cause: Priors were specified.
- ORA-40255: specified priors or weights table has an incorrect schema
-
Cause: The priors or class weights table whose name is specified in in the settings does not have the prescribed schema. A priors table should have the schema (target_value, prior_probability) and a class weights table should have the schema (target_value, class_weight)
- ORA-40261: input data for model build contains negative values
-
Cause: The input data contains negative values, which is not acceptable for a Non-negative Matrix Factorization model.
- ORA-40262: NMF: number of features not between [1, <varname>string</varname>]
-
Cause: The number of requested features must be greater than 1, and less than the smaller of the number of attributes and the number of cases in the dataset.
- ORA-40263: no meaningful matrix factorization found
-
Cause: Input data was not significantly different from 0.
- ORA-40264: number of mining attributes (<varname>string</varname>) exceeds maximum (<varname>string</varname>)
-
Cause: Input data was found to contain a number of mining attributes exeeding the maximum allowed.
- ORA-40271: no statistically significant features were found
-
Cause: Input data inadequate in volume and/or quality to derive statistically significant predictors for building a data mining model.
- ORA-40272: apply rules prohibited for this model mode
-
Cause: Adaptive Bayes Network rules are only generated for SingleFeature ABN models
- ORA-40273: invalid model type <varname>string</varname> for Adaptive Bayes Network algorithm
-
Cause: The valid values for the abns_model_type settings are: abns_multi_feature, abns_single_feature, abns_naive_bayes.
- ORA-40274: the Adaptive Bayes Network algorithm is desupported
-
Cause: An attempt was made to score an Adaptive Bayes Network model.
- ORA-40281: invalid model name
-
Cause: A model name is invalid or does not exist.
- ORA-40282: invalid cost matrix
-
Cause: Cost matrix specification is invalid.
- ORA-40283: missing cost matrix
-
Cause: Cost matrix specification is missing.
- ORA-40284: model does not exist
-
Cause: The model entered does not exist.
- ORA-40285: label not in the model
-
Cause: The user-specified label was not present in the model.
- ORA-40286: remote operations not permitted on mining models
-
Cause: An attempt was made to perform queries or DML operations on remote tables using local mining models.
- ORA-40287: invalid data for model - cosine distance out of bounds
-
Cause: The norm computed using attribute values from the incoming row for the cosine model is outside the range 0-1.
- ORA-40288: event to debug and trace mining model load
-
- ORA-40289: duplicate attributes provided for data mining function
-
Cause: A duplicate, non-nested attribute was provided as input to the data mining function. A duplicate attribute is one which is present in the model signature, occurs more than once in the USING clause after tablename expansion, and is not a collection element in a nested table column.
- ORA-40290: model incompatible with data mining function
-
Cause: The supplied model cannot be operated upon by the data mining function because the model is built for a mining function and/ or based on an algorithm that is incompatible with function.
- ORA-40291: model cost not available
-
Cause: The supplied model was assumed to have been built with a cost matrix specification, when in reality, it was not.
- ORA-40292: confidence level must be greater than 0 and less than 1
-
Cause: The specified value for confidence level is out of range.
- ORA-40293: input class is invalid for the specified predictive model
-
Cause: The specified model is either not a classification model, or does not have the input class label as one of its target values.
- ORA-40301: invalid cost matrix specification
-
Cause: A valid cost matrix is not specified.
- ORA-40302: invalid classname <varname>string</varname> in cost matrix specification
-
Cause: Actual or predicted classname specified is not present in training data
- ORA-40303: invalid prior probability specification
-
Cause: Valid prior probabilities not specified. Valid probabilities should be between 0 and 1.
- ORA-40304: invalid classname <varname>string</varname> in prior probability specification
-
Cause: Actual or predicted classname specified is not present in training data.
- ORA-40305: invalid impurity metric specified
-
Cause: Impurity metric specified is not valid. Examples of valid metrics are TREE_IMPURITY_GINI, TREE_IMPURITY_ENTROPY.
- ORA-40306: dm_nested types not supported by this algorithm
-
Cause: The training input to the CREATE_MODEL routine contained one or more columns of DM_NESTED type (DM_NESTED_NUMERICALS or DM_NESTED_CATEGORICALS). These columns are currently not supported by Orthogonal Partitioning Clustering (O-Cluster).
- ORA-40307: nested attribute combined name and value too long
-
Cause: The data that was presented to the decision tree algorithm was too long. The length is computed from the sum of the length of the nested attribute name and the length of the attribute value.
- ORA-40321: invalid bin number, is zero or negative value
-
Cause: Input bin number has zero or negative values.
- ORA-40322: bin number too large
-
Cause: Bin number is too large.
- ORA-40323: Attribute <varname>string</varname> has too many distinct values (<varname>string</varname>)
-
Cause: Exceeded maximum number of distinct values allowed in an attribute.
- ORA-40324: All rows contain the same data
-
Cause: All rows contained the same data and could not be clustered using k-Means with cosine distance metric.
- ORA-40341: access violation on model storage object
-
Cause: An attempt was made to directly access/modify a schema object that stores model metadata and content.
- ORA-40342: model was not correctly upgraded
-
Cause: An attempt was made to use a model, but the model was not correctly upgraded to the current release. This is most likely caused by importing a model from an old release without upgrading it, but could also be caused by a failed database upgrade.
- ORA-40343: invalid version specified in UPGRADE_MODELS
-
Cause: An invalid version was specified when invoking the UPGRADE_MODELS procedure. Valid values for the version are 10.2.0, 11.0.0, 12.0.0, and NULL.
- ORA-40350: One or more models exist that cannot be downgraded
-
Cause: There are data mining models in the database that were created in a release beyond the selected release for downgrade.
- ORA-40361: only SELECT and ALTER are valid for mining models
-
Cause: An attempt was made to grant or revoke an invalid privilege on a mining model.
- ORA-40362: invalid object <varname>string</varname>.<varname>string</varname> specified in the statement
-
Cause: An attempt was made to grant a privilege on an invalid object.
- ORA-40381: Invalid field specification for: <varname>string</varname>
-
Cause: The derived field was incorrectly defined.
- ORA-40382: More than one linear regression equation in the model
-
Cause: More than one linear regression equation was in the model.
- ORA-40383: No model found in PMML document
-
Cause: There was no model found in the PMML document.
- ORA-40384: Only one model allowed in PMML document
-
Cause: More than one model existed in the PMML document.
- ORA-40385: Target has more than two categories
-
Cause: The target contained more than two categories.
- ORA-40386: NormContinuous must include at least two LinearNorm elements
-
Cause: NormContinuous included less than two LinearNorm elements.
- ORA-40387: Invalid interval for Discretize field: <varname>string</varname>
-
Cause: The intervals were incorrect.
- ORA-40388: Unsupported feature in PMML document: <varname>string</varname>
-
Cause: The feature was not supported by PMML model import.
- ORA-40389: Unsupported PMML transformation: <varname>string</varname>
-
Cause: The transformation was not supported.
- ORA-40390: PMML DerivedField must have a unique name specified: <varname>string</varname>
-
Cause: A DerivedField did not reference another defined field.
- ORA-40391: PMML DerivedField depends on a undefined field: <varname>string</varname>
-
Cause: A DerivedField may only reference other defined fields.
- ORA-40392: PMML regression equation references an undefined field: <varname>string</varname>
-
Cause: Regression equation did not reference defined fields.
- ORA-40401: categorical attributes are not supported by this algorithm
-
Cause: The build data provided to the CREATE_MODEL routine contained one or more categorical attributes of types CHAR, VARCHAR2, or DM_NESTED_CATEGORICAL. These attributes are currently not supported for the SVD algorithm.
- ORA-40402: cannot output U matrix without a valid case identifier column
-
Cause: A U matrix was requested, but there was no case identifier column in the build data.
- ORA-40403: model does not have any valid features
-
Cause: All singular values in the SVD model were equal to zero. This can occur if the build data contains only zeros or all build columns have constant values and automatic data preparation is turned on.
- ORA-40404: approximate computation cannot be disabled for the build data
-
Cause: The build data had a very high number of attributes. An SVD model can be built only by enabling approximate computation.
- ORA-40421: missing text policy name
-
Cause: Text policy name was missing.
- ORA-40422: TEXT attribute types not supported by this algorithm
-
Cause: The training input to the CREATE_MODEL routine contained one or more attributes of TEXT type. These attributes are currently not supported by Orthogonal Partitioning Clustering (O-Cluster).
- ORA-40441: JSON syntax error
-
Cause: The provided JavaScript Object Notation (JSON) data had invalid syntax and could not be parsed.
- ORA-40442: JSON path expression syntax error
-
Cause: The provided JavaScript Object Notation (JSON) path expression had an invalid syntax and could not be parsed.
- ORA-40443: unsupported JSON path expression
-
Cause: The provided JavaScript Object Notation (JSON) path expression contained unsupported features.
- ORA-40444: JSON processing error
-
Cause: The requested JavaScript Object Notation (JSON) operation failed.
- ORA-40445: unsupported JSON operation
-
Cause: The requested JavaScript Object Notation (JSON) operation is not supported.
- ORA-40446: expecting keyword STREAM
-
Cause: The JavaScript Object Notation (JSON) operator expected the keyword STREAM.
- ORA-40447: expecting PASSING clause
-
Cause: The JavaScript Object Notation (JSON) operator expected a PASSING clause.
- ORA-40448: expecting RETURNING clause
-
Cause: The JavaScript Object Notation (JSON) operator expected a RETURNING clause.
- ORA-40449: invalid data type for return value
-
Cause: The provided data type for the return value was invalid or unsupported.
- ORA-40450: invalid ON ERROR clause
-
Cause: The provided ON ERROR clause was invalid.
- ORA-40451: invalid default value provided
-
Cause: The provided default value was not allowed here.
- ORA-40452: default value not matching type defined in RETURNING clause
-
Cause: The provided default value did not match the type defined in RETURNING clause.
- ORA-40453: JSON operator syntax error
-
Cause: The provided JavaScript Object Notation (JSON) operator had invalid syntax.
- ORA-40454: path expression not a literal
-
Cause: The provided path expression was not a literal (a constant).
- ORA-40455: default value not a literal
-
Cause: The provided default value was not a literal (a constant).
- ORA-40456: JSON_VALUE evaluated to non-scalar value
-
Cause: The provided JavaScript Object Notation (JSON) path expression selected a non-scalar value.
- ORA-40457: JSON path expression contained an invalid array index
-
Cause: The provided JavaScript Object Notation (JSON) path expression contained an invalid array index.
- ORA-40458: JSON_EXISTS used outside predicate
-
Cause: The operator JSON_EXISTS was used outside a predicate.
- ORA-40459: output value too large (actual: <varname>string</varname>, maximum: <varname>string</varname>)
-
Cause: The provided JavaScript Object Notation (JSON) operator generated a result which exceeds the maximum length specified in the RETURN clause.
- ORA-40460: default value too large
-
Cause: The provided default value exceed the maximum length specified in the RETURN clause.
- ORA-40461: Unsupported character set
-
Cause: The provided JavaScript Object Notation (JSON) operator does not supported the current database character set.
- ORA-40462: JSON_VALUE evaluated to no value
-
Cause: The provided JavaScript Object Notation (JSON) path expression did not select a value.
- ORA-40463: JSON path expression contained an invalid variable name
-
Cause: The provided JavaScript Object Notation (JSON) path expression contained a variable name that is not used in the PASSING clause.
- ORA-40464: JSON PASSING clause contained duplicate variable names
-
Cause: The provided JavaScript Object Notation (JSON) PASSING clause contained non-unique variable names.
- ORA-40465: JSON PASSING clause contained too many unnamed parameters
-
Cause: The provided JavaScript Object Notation (JSON) PASSING clause contained too many unnamed parameters.
- ORA-40466: Invalid parameter in IS [NOT] JSON predicate
-
Cause: The IS [NOT] JSON predicate containes an invalid parameter.
- ORA-40467: JSON_TEXTCONTAINS() cannot be evaluated without JavaScript Object Notation (JSON) index
-
Cause: There was no JSON-enabled context index available.
- ORA-40468: first input parameter to JSON_TEXTCONTAINS() must be a column
-
Cause: The first input parameter to JSON_TEXTCONTAINS() was not a column.
- ORA-40469: JSON path expression in JSON_TEXTCONTAINS() is invalid
-
Cause: A predicate or array position was used in JavaScript Object Notation(JSON) path expression.
- ORA-40470: JSON_VALUE evaluated to multiple values
-
Cause: The provided JavaScript Object Notation (JSON) path expression selected more than one value.
- ORA-40471: selected value not JSON array or object
-
Cause: The selected value was not a JavaScript Object Notation (JSON) value. (object or array)
- ORA-40472: invalid escape in JSON data
-
Cause: The provided JavaScript Object Notation (JSON) data had an invalid escape sequence.
- ORA-40473: duplicate key names in JSON object
-
Cause: The provided JavaScript Object Notation (JSON) data had duplicate key names in one object.
- ORA-40474: invalid UTF-8 byte sequence in JSON data
-
Cause: The provided JavaScript Object Notation (JSON) data had an invalid UTF-8 byte sequence.
- ORA-40475: JSON data nested too many levels
-
Cause: The provided JavaScript Object Notation (JSON) data had too many levels of nesting.
- ORA-40476: JSON key too long
-
Cause: The provided JavaScript Object Notation (JSON) data had a key which exceeds the maximum length.
- ORA-40477: internal JSON error
-
Cause: There was an internal error in the JavaScript Object Notation (JSON) processing layer.
- ORA-40478: output value too large (maximum: <varname>string</varname>)
-
Cause: The provided JavaScript Object Notation (JSON) operator generated a result which exceeds the maximum length specified in the RETURN clause.
- ORA-40479: internal JSON serializer error
-
Cause: There was an internal error in the JavaScript Object Notation (JSON) serializer).
- ORA-40480: result cannot be returned without array wrapper
-
Cause: The JavaScript Object Notation (JSON) path expressions selected a value that can only be returned inside an array.
- ORA-40481: ASCII or PRETTY not supported for non-textual return data type
-
Cause: An attempt was made to pretty print or escape non-ASCII characters for a non-textual output of a JSON operation.
- ORA-40482: JSON_TEXTCONTAINS() used outside predicate of WHERE clause
-
Cause: JSON_TEXTCONTAINS() was used outside of the predicate of a WHERE clause.
- ORA-40483: incorrect search string to JSON_TEXTCONTAINS()
-
Cause: An incorrect search string to JSON_TEXTCONTAINS() was used.
- ORA-40484: invalid data type for JSON_TABLE column
-
Cause: A column in the provided JSON_TABLE had an unsupported data type.
- ORA-40485: keyword PRETTY not valid for this column
-
Cause: A JSON_TABLE column with JSON_VALUE semantics could not be pretty printed.
- ORA-40486: array wrapper not valid for this column
-
Cause: A JSON_TABLE column with JSON_VALUE semantics could not have an array wrapper.
- ORA-40487: invalid usage of keyword EXISTS
-
Cause: A JSON_TABLE column with JSON_EXISTS semantics had invalid parameters.
- ORA-40488: invalid ON ERROR clause for column semantics
-
Cause: An ON ERROR clause was provided that was not valid for the selected column semantics.
- ORA-40489: keyword ASCII not valid for this column
-
Cause: A JSON_TABLE column with JSON_VALUE semantics could not be pretty printed.
- ORA-40490: COLUMNS clause required
-
Cause: The provided JSON_TABLE row source requires a COLUMNS clause.
- ORA-40491: invalid input data type for JSON_TABLE
-
Cause: The provided input to JSON_TABLE has an unsupported data type.
- ORA-40492: invalid column definition in JSON_TABLE
-
Cause: A column definition inside JSON_TABLE was invalid.
- ORA-40493: invalid option or parameter in JSON_TABLE
-
Cause: The provided JSON_TABLE definition contained one or more invalid options or parameters.
- ORA-40494: error during execution of JSON_TABLE
-
Cause: The provided JSON_TABLE definition could not be evaluated.
- ORA-40495: internal error in JSON_TABLE
-
Cause: The provided JSON_TABLE definition could not be evaluated.
- ORA-40497: only one ordinality column permitted
-
Cause: The provided JSON_TABLE definition contained more than one ordinality column.
- ORA-40498: binary format requested for non-binary data type
-
Cause: The provided JSON format was binary but the input data type was not binary.
- ORA-40499: no format defined for binary data type
-
Cause: The provided JSON input was of binary type but a format was not defined.
- ORA-40500: General event for JSON operations
-
- ORA-40501: cannot open an encrypted log file
-
Cause: An attempt was made to open a log file that has been encrypted for storage and management by the Oracle Availability Machine. Only the processes involved in shipping such a log to or from the Oracle Availability Machine can open the log.
- ORA-40551: internal BSON/JSON conversion error [<varname>string</varname>]
-
Cause: BSON/JSON conversion failed with internal error.
- ORA-40552: invalid data type
-
Cause: The BSON/JSON converter was invoked with an invalid data type.
- ORA-40553: path expression with predicates not supported in this operation
-
Cause: A path expression with predicates was specified in a JavaScript Object Notation (JSON) operation that does not support predicates.
- ORA-40554: invalid input data type in PASSING clause
-
Cause: The specified PASSING clause had an unsupported data type.
- ORA-40555: incorrect PASSING clause
-
Cause: The specified PASSING clause was invalid.
- ORA-40556: unsupported chaining of JSON_TABLE
-
Cause: The specified JSON_TABLES were chained.