WebDB Calendar Component: Date links constant throughout a given month.

1. Background. Building a calendar component as per WebDB reference: You can specify bind variables by prefixing them with colons (:). Column 1: the date Column 2: the displayed name --item Column 3: the name link (optional) --item_link Column 4: the date link (optional) Column 5: the target frame (optional)
2. Problem. Date links constant throughout a given month.
3. Solution. Modify WWV_RENDER_CALENDAR.SHOW_INTERNAL at line 262: (and hope that a future release of WebDB includes recommended change)

          <<TAR_1000176_999_FIX>>
          begin
               l_dlink := p_dlink(l_cnt);
          exception when others then
               l_dlink := null;
          end TAR_1000176_999_FIX;

 All the other fields are updated using similar blocks of code, but the code to update the date link inside the loop was left out of the package. The problem manifests itself in any calendar that has date links that are specific for a given day. All the date links in a given month will then erroneously be set to the value of the first date link encountered in that month.

4. Example. A calendar of scheduled items where clicking "the_date" will display a report of scheduled items for that date. Clicking a sheduled item ("the_name") will display the schedule item detail.

5. Remarks. Reported problem to Oracle via MetaLink automated TAR. Their response was: "called the ct back could not reach got voice mail, told the ct that this is the way the it is supposed to work; every date on the calnder will point to the samelink. the only way to get around this is to set parameters as note 72305.1 gives an example. sent ct email with the example code." However, Oracle's example does NOT even use the date_link.

Example: Received on Fri Sep 24 1999 - 19:06:57 CEST