|
From Our Readers
Your corrections, your opinions, and your requests: Here's your forum for telling us what's right and wrong in each issue of Oracle Magazine and for letting us know what you want to read.
Alternative Picks
In the article "Picking Your Packages," in the May/June 2005 issue of Oracle Magazine, Steven Feuerstein came to a conclusion I disagree with. It's not that I disagree that there may be times that a package is not appropriate. However, I can't think of such a case, and in a shop I'm running, a developer would need to come up with a much better reason than the one Steven provided to not use a package.
In the particular instance Feuerstein wrote about, I would say he was making his packages too generic. Packages should group similar functionality. Also, if a procedure is not appropriate for one package, that does not mean it is not appropriate for another—even one where, for now, it lives by itself.
To solve the problem he described, I think a better approach would be to redesign the procedure. Create a simple one-column, one-row table, and store the company tagline there. During package initialization, execute a query and populate a private package variable, so it will be available at runtime, using the supplied procedure.
Lewis Cunningham
lewisc@rocketmail.com
The Ancient Modern
The "Modern Design" cover on the May/June 2005 issue of Oracle Magazine activated my ancient brain, and I dredged up some images [from the de Stijl movement] I'd seen in my distant past:
www.artlex.com/ArtLex/d/destijl.html
This was "Modern Art" back in the 1910s through 1930s.
Perhaps you should have used an image from MTV or something even newer. Thank the muses we don't base our current applications and data warehouses on designs from 50 years ago.
Or perhaps we should?
Chuck Peterka
Chuck_Peterka@Vanguard.com
Getting Started
I've been a reader of Oracle Magazine for one year, and I'm not professional when it comes to Oracle products. I see that all the articles in your magazine are for professionals, so it's difficult for me to understand what you are talking about. My suggestion: Include a page or a corner of the magazine for amateurs like me.
Faruk Öztürk
faruk.ozturk@meysangroup.com
Please take a look at the resources provided via the Oracle Technology Network (OTN). Important stops for those new to Oracle products include "About Oracle Technology Network" and "Get Started with Oracle." In the documentation area, check out Oracle Database Concepts.
Altering Alterations
|
Send Mail to the Editor
Send your opinions about what you read in Oracle Magazine, and suggestions for possible technical articles, to opubedit_us@oracle.com.
Or click on the Write the Editors link on our Web site.
Letters may be edited for length and clarity and
may be published in any medium. We consider any communications we receive publishable.
|
As per your column "Tracing SQL in Oracle Database 10g," which appeared in the September/October 2004 issue of Oracle Magazine, I tried to change the location of user_dump_dest in Oracle Database 10g, and it doesn't work:
SQL> alter session set user_dump_dest=
'/vol101/ora10g';
alter session set user_dump_dest=
'/vol101/ora10g'
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this Option
Please advise if I am doing something wrong.
Bhimsingh Wadhwa
Bhimsingh.Wadhwa@Claria.com
The user_dump_dest parameter setting cannot be altered at the session level; it is altered at the system level. The correct syntax in the column should have been:
alter system set user_dump_dest=
"c:\kflosstrace";
The online version of the article has been corrected. (Please note that the author originally included the correct syntax in the draft she sent us. The error was introduced in the editorial process.)
| 
Bookmark
