Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

O2I-00124: Error opening the INITFILE file for writing

1 Answers  


ORA-38768: resizing datafile string failed

1 Answers  


PLS-00522: MAP methods must return a scalar type.

1 Answers  


SQL*Loader-00930: Error parsing insert statement for table string column string.

1 Answers  


SQL*Loader-00958: Error popping data relocation address stack

1 Answers  






ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

1 Answers  


ORA-01424: missing or illegal character following the escape character

1 Answers  


ORA-02472: PL/SQL functions not allowed in hash expressions

1 Answers  


ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.

1 Answers  


ORA-29303: user does not login as SYS

1 Answers  


QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing

1 Answers  


ORA-01266: Unable to create unique file name

1 Answers  






Categories