DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-YMail-OSG:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:X-Priority:X-MSMail-Priority:X-Mailer:In-Reply-To:Importance:X-MimeOLE;
  b=b0CuJ8WuQ0omGp+1fSmzX+AMRtQIyRgUkUUxAqDPPdiYE5bGSo0NkktfrttPwsuv4mHmeAGQlb+hFsyavcC7W6EOH4h9cZGvC++EpTYqUGkZvlbpqnRZ2iZK6NF3BoLUSZn/v7ImDhG4GVe0lLzoiAC9czbBa7s6pnlTO7EEMoc=  ;
From: "Robert Freeman" <robertgfreeman@yahoo.com>
To: <jkstill@gmail.com>,
 <dag@its.msstate.edu>
Cc: <oracle-l@freelists.org>
Subject: RE: publish a pl/sql pkg
Date: Sun, 16 Sep 2007 19:32:18 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOEEPKEFAA.robertgfreeman@yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0002_01C7F898.4B339E60"
In-Reply-To: <bf46380709150819v7489a2bxdc4f9b1a74ff906c@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: robertgfreeman@yahoo.com
------=_NextPart_000_0002_01C7F898.4B339E60
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I seem to have found a solution to that problem. It's called become a
manager. Then no one expects anything of a technical value out of you! :-)

RF


Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2

  -----Original Message-----
  From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org]On Behalf Of Jared Still
  Sent: Saturday, September 15, 2007 9:19 AM
  To: dag@its.msstate.edu
  Cc: oracle-l@freelists.org
  Subject: Re: publish a pl/sql pkg


  On 9/14/07, Doug Gernaat <dag@its.msstate.edu> wrote:
    i got a pl/sql pkg with some functions and procedures in it.
    it's working beautifully for other programs that use it within
    the same database environment.

    if i were to make this available to other depts within our
    enterprise, what route might you take? these other depts
    are using diff programming languages and databases for
    their web apps.


  Sharing is a great idea.

  Just keep in mind what will happen if people make use of it.

  * enhancements will be requested.  You will have to make them.
  * bugs may be found.  You will have to fix them
  * whatever data it relies on will be changed.  You will have to modify the
code.

  You will be maintaining this code for as long as you are with the company.

  It's not that I am trying to put a damper on your enthusiasm, you just
have
  to realize that no good deed goes unpunished.  ;)

  Been there, done that.  The most recent example is an app that had a
fairly
  good database design, and worked fairly well.  The rules changed, I spent
  80 hours (or more) adapting it, and I am still responsible for it.  It
will need
  changed again soon due to changes in its data sources.

  There's nothing wrong with this, other than it tends to interfere with
everything
  else that a DBA normally does, which all adds up to extra time spent
working.

  I've learned to be more careful what I volunteer for. :)

  Just food for thought...
  --
  Jared Still
  Certifiable Oracle DBA and Part Time Perl Evangelist

------=_NextPart_000_0002_01C7F898.4B339E60
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16441" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D266383101-17092007><FONT face=3DArial color=3D#0000ff =
size=3D2>I seem=20
to have found a solution to that problem. It's called become a manager. =
Then no=20
one expects anything of a technical value out of you! =
:-)</FONT></SPAN></DIV>
<DIV><SPAN class=3D266383101-17092007><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D266383101-17092007><FONT face=3DArial color=3D#0000ff =

size=3D2>RF<BR></FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<P><FONT size=3D2>Robert G. Freeman<BR>Oracle =
Consultant/DBA/Author<BR>Principal=20
Engineer/Team Manager<BR>The Church of Jesus Christ of Latter-Day=20
Saints<BR>Father of Five, Husband of One,<BR>Author of various geeky =
computer=20
titles<BR>from Osborne/McGraw Hill (Oracle Press)<BR>Oracle Database 11g =
New=20
Features Now Available for Pre-sales on Amazon.com!<BR>BLOG: <A=20
href=3D"http://robertgfreeman.blogspot.com/"=20
target=3D_blank>http://robertgfreeman.blogspot.com/</A><BR>Sig =
V1.2</FONT> </P>
<BLOCKQUOTE>
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20
  oracle-l-bounce@freelists.org =
[mailto:oracle-l-bounce@freelists.org]<B>On=20
  Behalf Of </B>Jared Still<BR><B>Sent:</B> Saturday, September 15, 2007 =
9:19=20
  AM<BR><B>To:</B> dag@its.msstate.edu<BR><B>Cc:</B>=20
  oracle-l@freelists.org<BR><B>Subject:</B> Re: publish a pl/sql=20
  pkg<BR><BR></FONT></DIV>On 9/14/07, <B class=3Dgmail_sendername>Doug =
Gernaat</B>=20
  &lt;<A href=3D"mailto:dag@its.msstate.edu">dag@its.msstate.edu</A>&gt; =
wrote:
  <DIV><SPAN class=3Dgmail_quote></SPAN>
  <BLOCKQUOTE class=3Dgmail_quote=20
  style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: =
rgb(204,204,204) 1px solid">i=20
    got a pl/sql pkg with some functions and procedures in it.<BR>it's =
working=20
    beautifully for other programs that use it within<BR>the same =
database=20
    environment.<BR><BR>if i were to make this available to other depts =
within=20
    our <BR>enterprise, what route might you take? these other =
depts<BR>are=20
    using diff programming languages and databases for<BR>their web=20
  apps.<BR><BR></BLOCKQUOTE></DIV><BR>Sharing is a great =
idea.<BR><BR>Just keep=20
  in mind what will happen if people make use of it. <BR><BR>* =
enhancements will=20
  be requested.&nbsp; You will have to make them.<BR>* bugs may be =
found.&nbsp;=20
  You will have to fix them<BR>* whatever data it relies on will be=20
  changed.&nbsp; You will have to modify the code.<BR><BR>You will be=20
  maintaining this code for as long as you are with the company. =
<BR><BR>It's=20
  not that I am trying to put a damper on your enthusiasm, you just =
have<BR>to=20
  realize that no good deed goes unpunished.&nbsp; ;)<BR><BR>Been there, =
done=20
  that.&nbsp; The most recent example is an app that had a fairly =
<BR>good=20
  database design, and worked fairly well.&nbsp; The rules changed, I=20
  spent<BR>80 hours (or more) adapting it, and I am still responsible =
for=20
  it.&nbsp; It will need<BR>changed again soon due to changes in its =
data=20
  sources.<BR><BR>There's nothing wrong with this, other than it tends =
to=20
  interfere with everything<BR>else that a DBA normally does, which all =
adds up=20
  to extra time spent working.<BR><BR>I've learned to be more careful =
what I=20
  volunteer for. :) <BR><BR>Just food for thought...<BR>-- <BR>Jared=20
  Still<BR>Certifiable Oracle DBA and Part Time Perl=20
Evangelist<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0002_01C7F898.4B339E60--

--
http://www.freelists.org/webpage/oracle-l