Skip to main content

First Day at the New Job

It’s Wednesday night, and I’m already ½ way through the first week of the new job. If I had $1 for each time I said “we” – meaning Oracle – I would be able to take the rest of the week off! I guess it will take some time before I can refer to Oracle as “them”.

Being on the outside is very different. No longer can I pop into MetaLink to look up a TAR or Bug. I can’t access any of the internal sites which I used to do on a daily, if not more frequent basis. Call it separation anxiety, but I guess daily habits take some time to break. It was especially weird not being at OpenWorld this week. From what I heard, it was going well with a ton of interest in HTML DB, as well as BPEL & Fusion.

Speaking of OpenWorld, I have also been reading about Oracle Raptor on Brian Duff & Wilfred’s blog. I’ve known about this project for some time, but obviously couldn’t comment until it was made public. I think that it’s about time that Oracle entered into this market. I remember back when I first started at Oracle, I was surprised that I had to rely on TOAD for basic schema maintenance & development.

Anyways, back to the new job. So far, so good. Aside from getting lost in the parking garage, which is more akin to medieval catacombs than a logically built parking structure, things have been going well. The new team has been quite busy, so aside from a couple of hours of orientation on Monday, I’ve been left alone to explore the application which I will be working on.

Once I proved that I knew how not to blow up a server, I was given all of the passwords to the development instance so that I could install HTML DB. I must say that it went quite fast on the 6-way HP machine. The only issue that I encountered was that some process had placed a lock on DBMS_LOCK, and the install couldn’t proceed. Thanks to Joel from the HTML DB team, I was able to resolve this as per a MetaLink Note.

After creating a new entry in the file, I ran into the same issue that someone on the Forums was having. Luckily, something sparked a distant memory of encountering this issue on another instance of the eBusiness Suite where I installed HTML DB, and I was able to recall how I solved it quickly.

Once HTML DB was installed, I integrated it with their Single Sign On server, so that we could use the same usernames from the eBusiness Suite. I then added a Responsibility and created an HTML DB Authorization Scheme based on it: If your user has this Responsibility, then you can access my HTML DB application.

Tomorrow, I’m going to create my first PL/SQL package to generate some sort of exception report. I’ve already been given the green light to do this in HTML DB, so I’m looking forward to that.

On another note, I watched jetBlue flight 292 land safely with a disabled nose gear at LAX live tonight. The pilots & crew of that flight should be commended, as it sounds like they treated this incident as nothing more than an “inconvenience”, all the while keeping the passengers informed and reassured every step along the way. As usual, the media made utter fools of themselves, asking the droves of aviation experts the most ridiculous questions via phone. My two favorites: 1) What role is the fire department playing? 2) Is it easier to land in clear weather than in, say a thunderstorm? Priceless.


Colin said…
"Being on the outside is very different. No longer can I pop into MetaLink to look up a TAR or Bug. I can’t access any of the internal sites which I used to do on a daily, if not more frequent basis."

Its a shame it is not more public. Given the level of career committment many of us make to using Oracle Product, just like Oracle Employees, its disappointing.

(Airline report, well, just the Mass Media looking for something to fill in air-time (pardon the pun) to avoid contraversial subjects, like the connection between Global Warming and frequent and fierce Hurricanes in the Gulf of Mexico area...)
Scott said…
Ya, they have to make their money somewhere, and its not like they are the only company who does it... I know that SAIC (and most companies) has a CSI somewhere, I just have to ask the right people to get it.
Anonymous said…
Mars is experiencing a similar "global warming" as we are. The sun is getting hotter. Giant volcanic explosions expunge more C02 and other "green house gases" into the atmosphere than years worth of what we humans add via cars and the like.
Anonymous said…
Configured HTMLDB to use SSO..and custom authentication scheme in HTMLDB to use a responsibility in R11i.

These are interesting topics and will be much appreciated if explained in a white paper or a blog topic.

Scott said…

You can read my White Paper on Integrating Oracle HTML DB with Oracle Application Server 10g for an overview of how to integrate the two products. Also, check out the SSO How To on OTN.

As for the 11i stuff, yes, that would make a nice entry!


- Scott -
Robert said…
heheh the media people trip over each other all of the time it is indeed funny to watch and hear.

Scott, re Raptor being developed by the HTML DB team...that true ?
It is java app right ?
If so then I am surprised because everything about HTML DB is so NOT JAVA.
Can you explain how the HTML DB team find time and the skills to doa Java project.
Scott said…

I clearly cannot speak for the HTML DB team's schedule anymore, as I am no longer a part of it. I can say that the team is made up of some incredbily talented people - some of whom are equally skilled in Java as they are in PL/SQL. Raptor is being developed by several development groups - HTML DB is just one of them lending a hand.


- Scott -
Anonymous said…
Hi Scott,

Is there a document somewhere which shows how to install HTMLDB on an Oracle Applications 11i installation? I have a 11.5.10 Vision installation on Linux and I want to implement HTMLDB on it as well.

Thanks for you help

Scott said…

Have a look at my presentation on Integrating Oracle eBusiness Suite with Oracle ApEx.


- Scott -
Anonymous said…

I have a question regarding your excellent presentation on Integrating Oracle eBusiness Suite with Oracle ApEx.

When integrating do you use a seperate install of Oracle Apache or are you configuring the Apache that 11i is already running.

Scott said…
When integrating do you use a seperate install of Oracle Apache or are you configuring the Apache that 11i is already running.

We used the HTTP server which was part of 11i. So as long as the version of the HTTP server is compatible with Apex, you should be able to piggy-back on to it.


- Scott -

Popular posts from this blog

Logging APEX Report Downloads

A customer recently asked how APEX could track who clicked “download” from an Interactive Grid.  After some quick searching of the logs, I realized that APEX simply does not record this type of activity, aside from a simple page view type of “AJAX” entry.  This was not specific enough, and of course, led to the next question - can we prevent users from downloading data from a grid entirely?

I knew that any Javascript-based solution would fall short of their security requirements, since it is trivial to reconstruct the URL pattern required to initiate a download, even if the Javascript had removed the option from the menu.  Thus, I had to consider a PL/SQL-based approach - one that could not be bypassed by a malicious end user.

To solve this problem, I turned to APEX’s Initialization PL/SQL Code parameter.  Any PL/SQL code entered in this region will be executed before any other APEX-related process.  Thus, it is literally the first place that a developer can interact with an APEX page…

Custom Export to CSV

It's been a while since I've updated my blog. I've been quite busy lately, and just have not had the time that I used to. We're expecting our 1st child in just a few short weeks now, so most of my free time has been spent learning Lamaze breathing, making the weekly run to Babies R Us, and relocating my office from the larger room upstairs to the smaller one downstairs - which I do happen to like MUCH more than I had anticipated. I have everything I need within a short walk - a bathroom, beer fridge, and 52" HD TV. I only need to go upstairs to eat and sleep now, but alas, this will all change soon...

Recently, I was asked if you could change the way Export to CSV in ApEx works. The short answer is, of course, no. But it's not too difficult to "roll your own" CSV export procedure.

Why would you want to do this? Well, the customer's requirement was to manipulate some data when the Export link was clicked, and then export it to CSV in a format…

Refreshing PL/SQL Regions in APEX

If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility.While the PL/SQL Region is quite powerful, it still lacks a key feature: the ability to be refreshed by a Dynamic Action. This is true even in APEX 5. Fortunately, there's a simple workaround that only requires a small change to your code: change your procedure to a function and call it from a Classic Report region.In changing your procedure to a function, you'll likely only need to make one type of change: converting and htp.prn calls to instead populate and return a variable at the end of the function. Most, if not all of the rest of the code can remain un…