This content has been marked as final. Show 3 replies
Are you running this as part of a PL/SQL procedure ? If so, what is the full procedure calling the query ?
Also, do you see the same error if you add a space to the query here -
WHERE E.Emp_ID IN ( SELECT Emp_id FROM employees)ORDER BY pa.id DESC ;
- change to -
WHERE E.Emp_ID IN ( SELECT Emp_id FROM employees) ORDER BY pa.id DESC ;
This is the forum for the SQL Developer tool, Not for general SQL/PLSQL questions. Please close this thread and repost in the PL/SQL forum.
PL/SQL doesn't work like TSQL. If you have a query within a PL/SQL block, you must fetch it INTO something ( a record or a set of scalar variables ) for processing.