Start a new topic

Exception when generating SELECT command

[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

[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