Home » Developer & Programmer » Forms » Rowid is getting selected automatically - raises error
Rowid is getting selected automatically - raises error [message #158496] Sun, 12 February 2006 05:23 Go to next message
karthikraj
Messages: 27
Registered: August 2005
Junior Member
When i query an lov i get this error.
That lov is based on an VIEW and i havent explicitly taken the ROWID in the view. But still when i query through the form or Database i get this error. In the backend if i remove the rowid and execute, then it is working fine. But in front end, forms, it is also taking the ROWID as first column and then giving the error.

I was not getting this error for a long time. When a new user is created by our admin, iam facing this error.

I suspect, the db is playing a role in this issue.

ORA-00604: error occurred at recursive SQL level 1
ORA-01401: inserted value too large for column
ORA-06512: at line 8
ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc.

Any help???

Report message to a moderator

Re: Rowid is getting selected automatically - raises error [message #158498 is a reply to message #158496] Sun, 12 February 2006 05:51 Go to previous message
karthikraj
Messages: 27
Registered: August 2005
Junior Member
My friend has helped to get the solution.
The DML target type was kept as table for this and after changing it to none, the issue was solved

Thanx

Report message to a moderator

Previous Topic: print report directly from form
Next Topic: help in testing a project
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:44:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.