Home » SQL & PL/SQL » Client Tools » Issue with PL/SQL Developer Version 8.0.4.1514 (Version 8.0.4.1514)
Issue with PL/SQL Developer Version 8.0.4.1514 [message #500557] Tue, 22 March 2011 04:16 Go to next message
delyanpeyankov
Messages: 4
Registered: March 2011
Location: Sofia, Bulgaria
Junior Member
Hi to all,

The described issue occurred last evening. I'll strongly appreciate any help on the resolving.

The issue is:

I am working with PL/SQL Developer Version 8.0.4.1514.

I a recently gain restricted privileges on one of the report DBs.

1) When I simply type a select statement (for example):

select * from db.******** c
where c.>>>> and should automatically show me all the rolls in the db.******** c after I type the dot (.) but it doesn't.

2) When I right click on the (for example):
db.******** table and the "describe" option is not available, so am unable to view the rolls in it.

The strange situation is that when i open a console "CMD" in "RUN" and type SQL> describe mb.******* and then I am able to see the columns, is it NULL and the Type (Varchar, NUM, etc.).


Any light on the issue will be strongly appreciated. Thanks a lot.



Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500563 is a reply to message #500557] Tue, 22 March 2011 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65384
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
select * from db.********

Quote:
describe mb.*******

For me, both do not point to the same object.

Regards
Michel
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500570 is a reply to message #500563] Tue, 22 March 2011 04:39 Go to previous messageGo to next message
delyanpeyankov
Messages: 4
Registered: March 2011
Location: Sofia, Bulgaria
Junior Member
YES, but
"describe mb.******* " through "CMD" in "RUN" is simply the same as right click on mb.******* >>> "Describe" in PL/SQL Developer

@Refer to question "2)"
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500572 is a reply to message #500570] Tue, 22 March 2011 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 65384
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Cannot see what you don't post.

Regards
Michel
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500628 is a reply to message #500557] Tue, 22 March 2011 08:07 Go to previous messageGo to next message
delyanpeyankov
Messages: 4
Registered: March 2011
Location: Sofia, Bulgaria
Junior Member
To be more specific I'll attach some shots.

1) When I simply type a select statement (for example):

select * from db.******** c
when I type c.>>>> and after the dot (.) should automatically show me all the rolls in the db.******** , but it doesn't.

This normally should happen:

* Refer to the screenshot - Capture1.JPG


/forum/fa/8818/0/


My question is it about a settings or it's about rights, because if I switch on the other DB and the functionality is working fine (Just like it's on the screenshot)


  • Attachment: Capture1.JPG
    (Size: 34.07KB, Downloaded 693 times)

[Updated on: Tue, 22 March 2011 08:09]

Report message to a moderator

Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500631 is a reply to message #500628] Tue, 22 March 2011 08:14 Go to previous messageGo to next message
delyanpeyankov
Messages: 4
Registered: March 2011
Location: Sofia, Bulgaria
Junior Member
The second question is:

2) When I right click on the (for example):

db.******** table and the "describe" option is not available, so am unable to view the rolls in it.

This usually should happen (Refer to the screenshot) when I right click, but "Describe" option is not available now.

/forum/fa/8819/0/

So it's working fine if A\m on the TEST DB, but on the report one the option is missing. Please consult, if you have an idea.
  • Attachment: Capture.JPG
    (Size: 27.00KB, Downloaded 693 times)
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500700 is a reply to message #500631] Tue, 22 March 2011 23:27 Go to previous messageGo to next message
davidjoe897
Messages: 1
Registered: March 2011
Location: ny
Junior Member
PL/SQL Developer is not an Oracle product.

You should probably refer your questions to the vendor or their forums:allroundautomations.com/plsqldev.html
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500713 is a reply to message #500700] Wed, 23 March 2011 01:16 Go to previous messageGo to next message
Littlefoot
Messages: 21361
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
True, it is not an Oracle product, but is a tool that is used to access an Oracle database. So what is the purpose of your first statement?

I guess that Delyan hopes that someone (who visits OraFAQ forum) might be able to help. I agree that people at All Round Automations probably know better (certainly much more than me, as I know absolutely nothing about PL/SQL Developer).
Re: Issue with PL/SQL Developer Version 8.0.4.1514 [message #500730 is a reply to message #500713] Wed, 23 March 2011 03:28 Go to previous message
Roachcoach
Messages: 1513
Registered: May 2010
Location: UK
Senior Member
I suppose the question is, what is the GUI actually doing when you click that "describe" button? There's often a number of ways to get info out of Oracle and depending on what said GUI uses to show its data...well your permissions might cause problems.

E.g. I know that SQL developer wants "execute any" on packages to see bodies, in the GUI rather than using DBMS_METADATA...


Maybe the GUI "describe" isn't executing the command "desc"
Previous Topic: iSQL*Plus stopped working unexpectedly (2 Merged)
Next Topic: @@ confusion
Goto Forum:
  


Current Time: Mon Feb 19 06:44:00 CST 2018

Total time taken to generate the page: 0.07978 seconds