PLS-00122: %s as separator is allowed only with specific
built-in functions



PLS-00122: %s as separator is allowed only with specific built-in functions..

Answer / guest

Cause: A few built-in functions use keywords (instead of
commas) as argument separators: Built-in function Argument
separators ---------------------------------------------
CHR, TRANSLATE USING CAST AS TRIM TRAILING, LEADING, BOTH,
FROM A function different from one of these built-in
functions is using a keyword as an argument separator.

Action: Correct the argument list or change the function name.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04085: cannot change the value of an OLD reference variable

1 Answers  


QSM-01003: no query rewrite on DDL queries

1 Answers  


ORA-32405: cannot alter tablespace for existing materialized view log

1 Answers  


RMAN-20005: target database name is ambiguous

1 Answers  


ORA-01177: data file does not match dictionary - probably old incarnation

1 Answers  






ORA-07432: unable to perform nested sleep

1 Answers  


PROC-00019: Cannot create more subkeys for the key

1 Answers  


QSM-01017: aggregate argument cannot be converted to canonical form

1 Answers  


ORA-13281: failure in execution of SQL statement to retrieve WKT

1 Answers  


ORA-00376: file string cannot be read at this time

1 Answers  


ORA-21700: object does not exist or is marked for delete

1 Answers  


ORA-14189: this physical attribute may not be specified for an index subpartition

1 Answers  


Categories