OraFAQ Forum: Client Tools » Issue with PL/SQL Developer Version 8.0.4.1514

Home » Other » Client Tools » Issue with PL/SQL Developer Version 8.0.4.1514 (Version 8.0.4.1514)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue with PL/SQL Developer Version 8.0.4.1514 [message #500557]

Tue, 22 March 2011 04:16

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.

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

select * from db.********

Quote:

describe mb.*******

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

Regards
Michel

Report message to a moderator

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

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)"

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Cannot see what you don't post.

Regards
Michel

Report message to a moderator

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

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 3039 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

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 2950 times)

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

Roachcoach
Messages: 1576
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"

Report message to a moderator

Previous Topic:	iSQL*Plus stopped working unexpectedly (2 Merged)
Next Topic:	@@ confusion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:47:05 CST 2024