| Package body not showing. [message #615578] |
Thu, 05 June 2014 10:36  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
I am having a user which is having package created and execute privs gievn to user B via roles.
User A's Package grant ------ > to role ------ > user B.
Now on toad, When I am logging into the Owner or System user, I am able to see package spec and package body, but When loging through user B, I am not able to see package body. only able to see package spec.
I also tried according the below link, but the problem is same. Please suggest.
http://www.orafaq.com/forum/t/53116/0/
Thanks in Advance
Pradeep Sharma
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Package body not showing. [message #615583 is a reply to message #615580] |
Thu, 05 June 2014 11:20  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
pradies wrote on Thu, 05 June 2014 21:20
I have already given direct grant to user B, but the problem is same.
So this is what I understand from what you say :
1. You login as user A in toad and view a package spec and body.
2. Logout user A, package spec and body is still open in the window.
3. Login again as user B, in the window you will still have the package loaded.
4. You try to view the package in object browser, but you only find the spec, and no body.
Please reply to the above 4 steps.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Package body not showing. [message #615607 is a reply to message #615605] |
Thu, 05 June 2014 23:02 |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Problem has been solved by some setting at toad level (View >>toad options >> schema browser >> Check box(right panel))
Quote:
Throw away TOAD, it is just b...t, and start to work like a professional using SQL*Plus.
I am a "professional" and behaving like a professional. But few are not, I am using only sql*plus or putty for working on database. Toad is not b...t. most of the developer using this TOAD option as developing in the development. asking all the question in this forum very politely.
Quote:doubt that TOAD is to blame in this case.
I am not blaming toad, just asking is there any thing missing related to grants or any option related to toad.
Quote:>I m a MCA, OCP certified DBA
OP has been here for SIX years!
once again this shows what OCP is worth.
Problem Exists Between Keyboard And Chair
Yes I am MCA and OCP ceritified but not knowing about each & every problem. and no one can. whenever any one facing issue first they are searching on net first. Same I am doing. If he/she will not get any solution, then he/she will look for help from other sources. I already mentioned that I already searched on net and followed the link mentioned in my first most post. Problem is not with keyboard and chair, problem with person's attitude. few people having good attitude like Lalit Kumar B but few are not.
Quote:You can't blame a gun because it shot someone. You can't blame a car because it hit someone. You can't blame TOAD because its users don't know how to properly use it.
Again I am not blaming toad. Just asked if something missing. I am not using this toad frequently. It's related development team problem and we are just trying to solve this. that's IT.
|
|
|
|
| Re: Package body not showing. [message #615608 is a reply to message #615607] |
Thu, 05 June 2014 23:19 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
pradies wrote on Fri, 06 June 2014 09:32
Problem has been solved by some setting at toad level (View >>toad options >> schema browser >> Check box(right panel))
Hmm, that's why I asked you :
Quote:
4. You try to view the package in object browser, but you only find the spec, and no body.
I have seen many developers with similar questions, that why I can't view any packages in the object browser. Or I only see the spec but no body. Always/most of the times it turns out to be an issue with the tool's settings or preferences.
|
|
|
|
|
|
|
|
| Re: Package body not showing. [message #615615 is a reply to message #615605] |
Fri, 06 June 2014 01:21 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Littlefoot wrote on Thu, 05 June 2014 23:19You can't blame a gun because it shot someone. You can't blame a car because it hit someone. You can't blame TOAD because its users don't know how to properly use it.
The same view you'd query in SQL*Plus can easily be queried in TOAD, only if you knew which one is it.
Do I know it? Of course not; I'd name it already. Why don't I search? Because it is painful to do that on a mobile phone.
I can't blame a gun because it shots someone, of course as a gun is made to shot people, but I can blame this gun for itself.
In the same way, I can blame TOAD to show source code. As a developer I never had to use any tool to see the code, my code is not stored in the database but in a code source tool. If I think the code is bad in the (dev) database, I reload it.
As a DBA I had to get the code ONLY when a team thinks there was an error in a delivery and they want to check (and my answer was "why not check the deliver file?", and their implicit answer was "because we do not trust DBA").
TOAD is designed to be misused, this is why it is a bad tool. A tool that does not help to learn its domain but turn their user to dumb people is a bad tool, more is a dangerous tool. I can't number the production downtimes due to TOAD use.
|
|
|
|
| Re: Package body not showing. [message #615617 is a reply to message #615615] |
Fri, 06 June 2014 02:21 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Michel
As a DBA I had to get the code ONLY when ...
See? We are talking from a different standpoint. I, as a developer, use TOAD every day, the whole day long (unless I'm working on forms, reports, an Apex application or something else). It is by far more convenient to have an editor which is capable of compiling my code and running it, without additional steps of reloading it from source code repository.
My code isn't stored in a database (of course, it exists there), it is kept in numerous files (packages, procedures, whatever). I just found that it is easier to work in TOAD than SQL*Plus. A simple "SELECT * FROM ..." is a nightmare in SQL*Plus, while it is neat in TOAD. I can see what I'm interested in in a matter of seconds, without formatting (COL DNAME FORMAT A10 ... oh, shit, it is too short/long, let me resize it).
To cut a long story short: you don't like it, I do, and there's nothing you can do about it (not that you'd want to).
|
|
|
|
| Re: Package body not showing. [message #615618 is a reply to message #615615] |
Fri, 06 June 2014 02:37 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 06 June 2014 11:51
TOAD is designed to be misused, this is why it is a bad tool.
Some, few, many wouldn't agree with that statement. Not that I am advocating the use of TOAD or anything else. A tool is meant to make work easy and efficient. Its use/misuse depends on the person and his level of understanding.
By the way, our own OraFAQ wiki says this
|
|
|
|
|
|
|
|
|
|
| Re: Package body not showing. [message #615659 is a reply to message #615624] |
Fri, 06 June 2014 09:52 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
You forgot the mankind.
Just kidding! Now, after a long debate, I think I understand what you are saying, and I agree with your last statements. TOAD can be dangerous. In SQL*Plus you have to learn stuff; otherwise, a syntax error prevents you from doing something stupid. With TOAD, you don't have to know anything much, click here & click there and oh shit, where did my data go? At the end, it comes back to individuals.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
