|
Replies:
1
-
Pages:
1
-
Last Post:
Mar 20, 2008 3:12 AM
Last Post By: Roger Bjarevall
|
|
|
Posts:
62
Registered:
11/17/06
|
|
|
|
Exception when generating SELECT command
Posted:
Mar 18, 2008 2:57 PM
|
|
|
|
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
|
|
Posts:
4,566
Registered:
12/17/04
|
|
|
|
Re: Exception when generating SELECT command
Posted:
Mar 20, 2008 3:12 AM
in response to: Chris
|
|
|
|
Chris,
This is a problem that we will fix in the next version.
Thanks for your report!
Best Regards
Roger
|
|
|
|
