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-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


ORA-01207: file is more recent than controlfile - old controlfile

1 Answers  


ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  


TNS-00506: Operation would block

1 Answers  


TNS-04208: Trace Assistant Internal ERROR: Fatal

1 Answers  






NNO-00322: statistic counter dump interval changed to number seconds

1 Answers  


RMAN-08586: output filename=string tag=string recid=string stamp=string

1 Answers  


NNL-00201: Shutdown occurs in string

1 Answers  


ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

1 Answers  


ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

1 Answers  


ORA-00396: error string required fallback to single-pass recovery

1 Answers  


ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  


Categories