01400-01799: FIPS Warnings
This section lists the warnings that can be issued by the FIPS Flagger when it is enabled in an Oracle tool (such as Server Manager, SQL*Plus, or an Oracle Precompiler) and either
- an Oracle extension to the SQL92 standard is used, or
- a SQL92 feature is used in a non-conforming manner
FIPS warning messages are listed for completeness. The causes and actions are described in ANSI document ANSI X3.135-1992.
PLS-01400: use of ||' token
PLS-01401: identifier over 18 characters long
PLS-01402: use of quoted identifier
PLS-01403: Comment delimiters /* */
PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character
PLS-01405: under ANSI's grammar, numeric data represented in exponent notation must use an uppercase E
PLS-01406: an identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's
PLS-01407: one of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer
PLS-01408: use of & token
PLS-01409: use of PRIOR_ token
PLS-01410: use of MOD token
PLS-01411: use of REM token
PLS-01412: use of EXP token
PLS-01413: use of NULL an expression
PLS-01414: use of qualified expression here
PLS-01415: use of aggregate value here
PLS-01416: use of <id> (<value>...) here
PLS-01417: use of %attribute
PLS-01418: subquery cannot include set operators in ANSI's grammar
PLS-01419: subquery must have either *' or exactly one column in its select list
PLS-01420: INTERSECT and MINUS set operators are not ANSI
PLS-01421: FOR UPDATE clause
PLS-01422: aliases
PLS-01423: subquery on right-hand-side in set clause
PLS-01424: non-ANSI order of clauses
PLS-01425: connect-by clause
PLS-01450: this <value expression> contains a nonconforming datatype
PLS-01451: the datatypes of these <value expressions> must be comparable
PLS-01452: this function is not part of the ANSI standard
PLS-01453: this procedure is not part of the ANSI standard
PLS-01454: no operator may be used with values of datatype CHAR
PLS-01455: the predicates IS NULL and IS NOT NULL are defined only for column specifications
PLS-01456: name length cannot exceed 3.
PLS-01458: the set clause in an UPDATE statement requires a column name of length 1
PLS-01460: cannot access object on a remote host
PLS-01463: STDDEV is not a standard set function
PLS-01464: VARIANCE is not a standard set function
PLS-01466: null strings are not allowed
PLS-01467: the value list of the IN predicate, if not a subquery, must contain only value_specifications
PLS-01468: the first argument of the like-predicate must be a column of type character string
PLS-01469: ANSI standard does not permit records
PLS-01470: the escape character in the like-predicate must be a literal or a variable of type CHAR
PLS-01471: the keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)
PLS-01472: in a set_function_specification, if DISTINCT is present, the expression must be a column_specification
PLS-01473: use <> instead of != or ~=
PLS-01474: use of ANY is non_ANSI
PLS-01500: unions are not allowed in the definition of a view
PLS-01501: options in CREATE TABLE statement is non-ANSI.
PLS-01502: constraint name and constraint status are non-ANSI.
PLS-01503: the expression in a SET clause must not include a set function
PLS-01504: use of AS phase in CREATE TABLE statement is non_ANSI
PLS-01505: ALTER is non-ANSI
PLS-01506: CREATE INDEX is non-ANSI
PLS-01507: DROP is non-ANSI
PLS-01701: illegal syntax in ROLLBACK WORK statement
PLS-01702: illegal syntax in COMMIT WORK statement
PLS-01703: cursor name in CLOSE statement must be of length 1
PLS-01704: the expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC
PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY
PLS-01707: in positioned DELETE or UPDATE statement, table must be identified in specification of cursor
PLS-01708: in searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition
PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification
PLS-01710: in a positioned DELETE or UPDATE statement, the cursor name must be of length 1
PLS-01711: a SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause
PLS-01712: ANSI does not allow bind variables as INDICATORS
PLS-01713: the constraints on these types do not match
PLS-01714: ANSI expects a column name not a literal value here
PLS-01715: ANSI does not accept SAVEPOINTs
