Oracle Message PLS-01419 - Subquery must have either * or exactly one column in its select list

ERRORSubquery must have either * or exactly one column in its select list
CAUSESubquery must have either * or exactly one column in its select list according to ANSIs grammar.
ACTIONNone