All posts by mpbod

PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification

oracle

PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification
Cause: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

oracle

PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)
Cause: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr).
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHAR

oracle

PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHAR
Cause: The escape character in the like-predicate must be a literal or a variable of type character.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01469: ANSI standard does not permit records

oracle

PLS-01469: ANSI standard does not permit records
Cause: ANSI standard does not permit records.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01468: The first argument of the like-predicate must be a column of type character string

oracle

PLS-01468: The first argument of the like-predicate must be a column of type character string
Cause: The first argument of the like-predicate must be a column of type character string.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications

oracle

PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications
Cause: The value list of the IN predicate, if not a subquery, must contain only value_specifications (that is, literals and PL/SQL or embedded variables).
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01466: Null strings are not allowed

oracle

PLS-01466: Null strings are not allowed
Cause: Null strings are not allowed.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01464: VARIANCE is not a standard set function

oracle

PLS-01464: VARIANCE is not a standard set function
Cause: VARIANCE is not a standard set function.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01463: STDDEV is not a standard set function

oracle

PLS-01463: STDDEV is not a standard set function
Cause: STDDEV is not a standard set function.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-01460: Cannot access object on a remote host

oracle

PLS-01460: Cannot access object on a remote host
Cause: Cannot access object on a remote host.
Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/