[This topic is migrated from our old forums. The original author name has been removed]
When I try to generate a SELECT statement from a view by right-clicking it in the objects tree and choosing "Script Object to SQL Editor" -> "SELECT", I get the following exception:
An error occurred while executing the database request for:
Oracle
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
Oracle JDBC driver
10.2.0.3.0
Short message:
ORA-01702: a view is not appropriate here
The command that caused the problem:
Get column info for BAS_CLAIMRELATION
Long Message:
ORA-01702: a view is not appropriate here
Details:
Type: com.onseven.dbvis.G.B.L
System Information:
Product: DbVisualizer Personal 6.1.1.1
Build: #1301 (2008/02/28 12:01)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.5.0_12-b04
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1
Cheers,
Chris
1 Comment
Roger Bjärevall
said
over 16 years ago
[This reply is migrated from our old forums.]
Re: Exception when generating SELECT command
Chris,
This is a problem that we will fix in the next version.
Thanks for your report!
Best Regards
Roger
anonymous