PLS-00486
select list cannot be enclosed in parentheses
Cause
In a SELECT statement, the select list was enclosed in parentheses, as in: SELECT (deptno, dname, loc) FROM dept INTO ... This breaks the rules of SQL syntax. Parentheses are not required because the keywords SELECT and FROM delimit the select list.
Action
Remove the parentheses enclosing the select list.