Re: problem with a trigger ++ UTL_GDK

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 19 Dec 2003 16:21:15 -0500
Message-ID: <n8KdnZccbL6Q8X6i4p2dnA_at_comcast.com>


"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1071861576.914618_at_yasure...
| Mark C. Stock wrote:
|
| > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
| > news:1071779320.592407_at_yasure...
| > | Frank wrote:
| > |
| > | >
| > | > The sheer simplicity of it - beautiful.
| > | > What if TO_CHAR(sysdate,'DY') delivers 'ZON'?
| > | > Same dependencies... (now on NLS_LANG)
| > |
| > | I think that is why they invented UTL_GDK and other tools.
| > |
| >
| > daniel,
| >
| > i find no documentation on UTL_GDK, only one reference in MetaLink, and
only
| > one reference in newgroups (your post), but looking at the comments in
the
| > package spec, i don't see how this would help here
| >
| > can you shed some light?
| >
| > -- mcs
|
| Here's a link to my resource page built for the Puget Sound Oracle Users
| Group.
|
| http://www.psoug.org/reference/utl_gdk.html
|
| I found quite a bit on it at http://tahiti.oracle.com.
|
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|

not much help, daniel

searched tahiti under 9.2, 9.0.1, 8.1.7 -- no hits for UTL_GDK or just GDK

your reference shows syntax, but shows nothing related to the determining which day of week is sunday

looks like UTL_GDK simply supports mapping oracle NLS values to ISO values -- useful stuff, but not applicable here

do you have any usage examples/scenarios?

  • mcs
Received on Fri Dec 19 2003 - 22:21:15 CET

Original text of this message