SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG. Version 1.0.47 BETA

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
BUG. Version 1.0.47 BETA
Author Message
mmx



Joined: 05 Dec 2006
Posts: 8

Post BUG. Version 1.0.47 BETA Reply with quote
Oracle 10g.

At serial input assistent can't find element in the list.

Sample.
vms_univers - not found whereas he is on the list.
Tue Dec 05, 2006 5:03 am View user's profile Send private message ICQ Number
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Could you please provide more details? It is not clear what you wanted to say

What is "vms_univers?" Is that a table, column, package, procedure, function, mat view, synonym? In which case it cannot be found? in which part of SQL command? What type of editor?
Tue Dec 05, 2006 9:00 am View user's profile Send private message
mmx



Joined: 05 Dec 2006
Posts: 8

Post Reply with quote
vms_univers - view
Editor - TOAD 8.5 - it matters ?

part of SQL command - select * from ????

others SQL commands not test.

vms_univers - object is in the objects lists.
Tue Dec 05, 2006 10:57 am View user's profile Send private message ICQ Number
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
I guess you are simply connecting SQL Assistant to a different database. Please check if you have multiple Oracle clients installed on your computer. In client settings you likely have same TNS names but pointing to different databases, as a result in Toad you connect to a database where the mentioned view is present and in SQL Assistant you connect to a database where it is not.

If my guess is correct, please update your TNSNAMES.ORA files and make them point to the same database.
Tue Dec 05, 2006 1:24 pm View user's profile Send private message
mmx



Joined: 05 Dec 2006
Posts: 8

Post Reply with quote
I have one oracle client. i'm verify.

My tnsnames.ora:
# tnsnames.ora Network Configuration File: D:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.96.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

!!!! Required element exist in the list of assistant !!!
Therefore you virsion exlude.
Wed Dec 06, 2006 3:01 am View user's profile Send private message ICQ Number
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Here are images demonstrating the issue (emailed by mmx)

Before typing "vms"


after

Wed Dec 06, 2006 8:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Did you modify "Objects" query in SQL Assistant options by any chance?
Wed Dec 06, 2006 1:10 pm View user's profile Send private message
mmx



Joined: 05 Dec 2006
Posts: 8

Post Reply with quote
No.
select
object_name, substr(object_type,1,2)
from
all_objects
where
owner = :OWNER
and object_type in (
'TABLE','VIEW',
'PROCEDURE','FUNCTION','PACKAGE',
'MATERIALIZED VIEW','MATERIALIZED VIEW LOG'
)

union all
select
synonym_name,
decode(owner,'PUBLIC','SP','SN')
from
all_synonyms
where
owner in (:OWNER,decode(user,:OWNER,'PUBLIC',''))
and instr(synonym_name,'/') = 0

order by 1
Thu Dec 07, 2006 2:23 am View user's profile Send private message ICQ Number
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Hi. This should be fixed in the latest build 1.0.49. Please download and check if it works for you.
Thu Dec 07, 2006 12:40 pm View user's profile Send private message
mmx



Joined: 05 Dec 2006
Posts: 8

Post Reply with quote
EEE!!! All works!
Thanks!
Fri Dec 08, 2006 3:35 am View user's profile Send private message ICQ Number
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.