Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
PL/SQL Developer
Filter My Invalid objects + Triggers folder
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
Filter My Invalid objects + Triggers folder
#61638
05/15/20
09:21 AM
Joined:
Jun 2018
Posts: 46
Ukraine, Odessa
B
Buzz_ss
OP
Member
OP
Buzz_ss
Member
B
Joined:
Jun 2018
Posts: 46
Ukraine, Odessa
Hello
I have found little issue in object browser.
Reproduce:
1)Choose "My Invalid objects" in filter combobox.
2)Try expand folder "Triggers"
In this case I receive error :
"ORA-00918: column ambiguously defined".
Now in "where clause" for "My Invalid objects" it is written :
[quote]owner = user
and status = 'INVALID' [/quote]
How can I change this definition for fix this issue?
Thanks
Sergiy Buzadzhi
Copy Link to Clipboard
Re: Filter My Invalid objects + Triggers folder
Buzz_ss
#61639
05/15/20
02:34 PM
Joined:
Aug 1999
Posts: 22,220
Marco Kalter
Member
Marco Kalter
Member
Joined:
Aug 1999
Posts: 22,220
We'll fix this!
To fix this you can start PL/SQL Developer without connecting, go to Configure > Object Browser Filters, select the "My invalid objects" filter, and change "status" to "o.status".
Marco Kalter
Allround Automations
Copy Link to Clipboard
Re: Filter My Invalid objects + Triggers folder
Buzz_ss
#65299
01/23/24
06:27 PM
Joined:
Aug 2009
Posts: 18
Frisco, TX
fyzm7357
Member
fyzm7357
Member
Joined:
Aug 2009
Posts: 18
Frisco, TX
Just noticed this is still an issue (or reappeared) in 15.0.4. The workaround Marco provided still works.
Copy Link to Clipboard
Re: Filter My Invalid objects + Triggers folder
Buzz_ss
#65301
01/24/24
10:31 AM
Joined:
Aug 1999
Posts: 22,220
Marco Kalter
Member
Marco Kalter
Member
Joined:
Aug 1999
Posts: 22,220
We'll fix it for 15.0.5!
Correction: it's already fixed, but the fix will not help for pre-existing filters. It will only help for new PL/SQL Developer users.
Last edited by Marco Kalter;
01/24/24
10:36 AM
.
Marco Kalter
Allround Automations
Copy Link to Clipboard
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
Plyxon Alpha / Beta
PL/SQL Developer 15.0 Beta
Print Thread
Switch to Threaded Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:
PHP:
7.1.33
Page Time:
0.090s
Queries:
14 (0.038s)
Memory:
2.5086 MB (Peak: 3.0420 MB)
Data Comp:
Off
Server Time:
2024-05-17 07:20:20 UTC
Valid HTML 5
and
Valid CSS