#1 browse view containing UNION

[Johannes]

I am using phpOraAdmin for my sql database project for
school. For the project I needed to make a view that
had a number of UNION's. The creation of the views
worked but when I used the Browse function it gave the
following error:
|SQL query:
|
|SELECT * FROM VLUCHTINFO
|
|Warning: ociexecute(): OCIStmtExecute: ORA-01446: cannot
|select ROWID from view with DISTINCT, GROUP BY, etc.

I thought I made a mistake creating the view but after
a while I tried making the view using SQLPlus. That
worked so I tried to use the view in my website and it
worked.

When I removed all the UNION's from the view it gave no
error.

For some reason executing SELECT * FROM VIEWNAME; gives
this error when executed via phpOraAdmin.

Johannes De Ridder