- 1. Oracle: order by subquery missing right parenthesis
- / Oracle PL/SQL /
- ... the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g ...
- Created on 05 December 2013
- 2. No rows returned in Oracle causes SP to fail
- / Oracle PL/SQL /
- ... but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty ...
- Created on 24 January 2012