ORA-01789 query block has incorrect number of result columns
What causes an ORA-01789 error?
All of the queries participating in a set expression do not contain the same number of SELECT list columns.
How Xynomix can help
Check that all the queries in the set expression have the same number of SELECT list columns.
Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.