This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes java.sql.SQLException: ORA-01733: virtual column not allowed here Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-01733: virtual column not allowed here" Watch "java.sql.SQLException: ORA-01733: virtual column not allowed here" New topic
Author

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

Dhamodharan Krishnan
Greenhorn

Joined: Nov 07, 2001
Posts: 23
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.


Dhamodharan Krishnan,<br />Sun Microsystems, Bangalore<br />Direct : 91-80-4184 7247<br />Cell : 91-99 80 147 600
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

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 ]
 
Consider Paul's rocket mass heater.
 
subject: java.sql.SQLException: ORA-01733: virtual column not allowed here
 
Similar Threads
ORACLE JDBC ERROR ORA-00600
invalid host/bind variable name
Callign an oragle package in Java with JDBC
JDBC connection using eclipse ide
ORA-01002: fetch out of sequence when trying to insert CLOB data into Oracle