ORA-31054: The string operator cannot have an ancillary operator



ORA-31054: The string operator cannot have an ancillary operator..

Answer / guest

Cause: An ancillary operator was used with an operator which
does not does not support ancillary operators

Action: Remove the ancillary operator in the query

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16222: automatic Logical Standby retry of last action

1 Answers  


PCC-02325: illegal indirection operation

1 Answers  


ORA-16216: Log stream sequence error

1 Answers  


NPL-00313: requested form string does not match actual form string

1 Answers  


ORA-24906: invalid recepient attribute passed into OCI call

1 Answers  






ORA-09261: spdcr: error creating detached (background) process

1 Answers  


RMAN-06596: to use CONVERT compatibility must be set to 10.0.0 or greater, currently set to string

1 Answers  


NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 Answers  


QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.

1 Answers  


ORA-23343: no match for specified conflict resolution information

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


ORA-01453: SET TRANSACTION must be first statement of transaction

1 Answers  


Categories