Posts:
478
Registered:
8/10/06
|
|
|
|
RE: No values in Debug, values when executed alone
Posted:
Feb 10, 2010 9:51 AM
in response to: Eva
|
|
|
Do you have more than 1 table/view/syn for that name? If it were a priv
issue, I?d think you?d get a table not found ORA message.
|
Follow me on twitter @hillbillyToad
Check out my blog on ToadWorld
|
|
|
|
|
|
RE: No values in Debug, values when executed alone
Posted:
Feb 10, 2010 11:43 AM
in response to: Eva
|
|
|
Hi Eva;
Odds are Bert is correct. You are accessing two different objects.
I’ll wager you’ll find a private object, most likely a synonym,
owned by the package owner pointing at one object owned by schema A (not the
package owner) and you’ll also find a public synonym pointing at the same
named object owned by schema B (also not the package owner).
What makes most sense is that your stand-alone SQL is accessing your private
synonym and running the code is accessing the public synonym.
The rights granted on the object the public synonym is pointing to –
Schema B - is most likely granted to public. This is the same as being directly
granted to the package owner. On the other hand, the rights granted to the
object in schema A would be granted to the package owner through a role rather
than directly.
This is a scenario that fits what Bert was describing and all the clues
you’ve provided to your puzzle.
Roger S.
|
|
|
|
|
|
|
RE: How can I turn on AUTOCOMMIT?
Posted:
Feb 10, 2010 11:47 AM
in response to: Norm [TeamT]
|
|
|
>> I wonder how many people out there in Toad Land actually turn autocommit on?
Heh, one of the things I look for on a database is to see what the default
behavior is and if commit is on, I set up a SOP to ensure it’s turned off
for any session I’m working on.
Thankfully I’ve never had to have the pleasure of a DBA who has ever set
the default database behavior as commit.
Roger S.
|
|
|
Posts:
343
Registered:
2/4/09
|
|
|
|
RE: How can I turn on AUTOCOMMIT?
Posted:
Feb 11, 2010 1:07 AM
in response to: erwin.rollauer@...
|
|
|
Hi Erwin,
>> I realize I was sort of comparing apples and oranges.
No worries.
>> You were talking about standards for DBA run scripts and I was
>> trying to apply them to operations run production jobs. Do
>> you by the way have a set of script standards for that?
At the moment, no. Simply because we don't have regularly scheduled
tasks that run against a database. However, if we did have, then:
* they would run under the control of DBMS_JOB or DBMS_SHEDULER as
appropriate and not externally from cron/windows scheduler.
* they would have to pass through the normal QA process as well.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
