For a procedure (or function) in a package, you can assign default values only in the package specifications without assigning them in the package body:
SQL> CREATE OR REPLACE PACKAGE test_default_pkg AS
PROCEDURE set_global (p_num IN NUMBER DEFAULT 1);
Package TEST_DEFAULT_PKG compiled
SQL> SHOW ERRORS;
SQL> CREATE OR REPLACE PACKAGE BODY test_default_pkg AS
PROCEDURE set_global (p_num IN NUMBER) AS
Package body TEST_DEFAULT_PKG compiled
SQL> SHOW ERRORS;
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
PeopleSoft Tipster Blog
So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.
Amazingly, the (more...)
Next up in our ‘How I Work‘ series is Dan Iverson. Dan – together with partner-in-crime Kyle – runs the PSAdmin.io blog. If you’re a PeopleSoft administrator and connected to the Internet then there’s no doubt that you’ll have heard of their blog as they’re really prolific and have posted some great content. Clearly blogging wasn’t enough however, and there is now the PeopleSoft Administrator PodCast which is ~45 minutes of topical awesomeness. I (more...)
Happy New Year! No predictions from me for 2016...we've all seen how poorly that works out. No resolutions either (although I may open a fitness gym called "Resolutions"...the place converts into a bar at the end of January). Instead, I simply leave you with the wisdom of Dr. Seuss; something to consider as you kick off the new year.
The Zode In The Road
Did I ever tell you about the young (more...)
At this time of the year during holidays, the Apps DBA community is busy doing upgrades as longer downtimes are possible. In case you are facing any issues, please feel free to write to me at my email: firstname.lastname@example.org . I will be glad to hear from you and help you.
I've been going through an amazing experience over the past month plus...purchased and began wearing an Apple iWatch. Never really thought I would do so...kind of did it on the spur of the moment. Plus a little push from my team lead at Oracle, who wears one and loves it.
Even after a month of wearing the iWatch, I can't really point at one particular feature that makes it worthwhile. It's really more (more...)
Over the month since I've joined Oracle, many people has asked about the work I'm doing here. And, in all honesty, the work is so varied that I've had a difficult time describing it.
Yesterday, I was traveling from my home in Salt Lake to Oracle Corporate HQ in Redwood Shores. Having landed in San Francisco, I was in a rush to get my rental car, make the drive to HQ, and get (more...)
While launching twm, it gives this error and exits to unix prompt:
twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"
I found a solution on http://ubuntuforums.org/archive/index.php/t-1596636.html :
It was reported here for fedora: https://bugzilla.redhat.com/show_bug.cgi?id=509639. The workaround is to execute it with a specific shell variable:
$ export LANG
twm launches fine after this.