Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - BETA versions

Thread: Exception when generating SELECT command


Permlink Replies: 1 - Pages: 1 - Last Post: Mar 20, 2008 3:12 AM Last Post By: Roger Bjarevall
Chris

Posts: 63
Registered: 11/17/06
Exception when generating SELECT command
Posted: Mar 18, 2008 2:57 PM
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,053
Registered: 12/17/04
Re: Exception when generating SELECT command
Posted: Mar 20, 2008 3:12 AM    global.in_response_to.tooltip in response to: Chris
   thread.click_reply Reply
Chris,

This is a problem that we will fix in the next version.

Thanks for your report!

Best Regards

Roger

Point your RSS reader here for a feed of the latest messages in all forums