Message Oracle ORA-29508 - query derived from USING clause did not select a value of type string

ERRORquery derived from USING clause did not select a value of type string
CAUSEThe USING clause did not form a query that selects a value of the type specified by the term following the USING keyword.
ACTIONCorrect the USING clause.