Re: Don't understand ora-01789 error

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 15 May 2001 21:17:07 -0500
Message-ID: <u3da6rqf4.fsf@primix.com>

On Tue, 15 May 2001, dontreply_tdykstra_at_cfol.ab.ca wrote:

> I have a view which contains a Union All statement. I can do
> 'select * from myview', but when I try to do 'select col1 from
> myview' or 'select count(*) from myview' I get error ora-01789.
> I don't understand what that error means.
>

FROM http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/e1500.htm#1003914 ,----

| ORA-01789 query block has incorrect number of result columns
| 
| Cause: All of the queries participating in a set expression do
|        not contain the same number of SELECT list columns.
| 
| Action: Check that all the queries in the set expression have the
| same number of SELECT list columns.

`----

I haven't encountered this error before. Can you post the text of the view?

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.

Received on Tue May 15 2001 - 21:17:07 CDT