Share

phpOraAdmin

Tracker: Bugs

5 browse view containing UNION - ID: 1377778
Last Update: Tracker Item Submitted ( virtualjj )

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


Johannes ( virtualjj ) - 2005-12-10 17:31

5

Open

None

Nobody/Anonymous

None

None

Public


Comments




Log in to comment.

No follow-up comments have been posted.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.