Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: ORA-01733: virtual column not allowed here

 
Dhamodharan Krishnan
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

I am doing a select and then update on the resultset.
But I am getting the following exception.



Steps followed

getConnection();
create PrepareStatement.
Set teh values for querying.
executeQuery and get ResultSet

Update teh values in teh ResultSet.

Call updateRow of the ResultSet.


But this says virtual column not allowed here.

I have no clue. I am badly dependent on select and update.

Thanks in advance for your help.

Dhamo.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you even try Google?

ORA-01733:
virtual column not allowed here
Cause:
An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view.
Action:
INSERT, UPDATE, or DELETE data in the base tables, instead of the view.
[ September 09, 2005: Message edited by: David O'Meara ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic