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-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


ORA-25504: the system is already in quiesced state

1 Answers  


QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  


PLS-01474: Use of ANY is non_ANSI

1 Answers  






ORA-12657: No algorithms installed

1 Answers  


ORA-01317: Not attached to a Logminer session

1 Answers  


ORA-21600: path expression too long

1 Answers  


NZE-29159: Unable to read library.

1 Answers  


LSX-00342: value of attribute "base" must be a complex type definition

1 Answers  


ORA-29296: invalid encoded string

1 Answers  


ORA-22912: specified column or attribute is not a nested table type

1 Answers  


Categories