Re: publish a pl/sql pkg

  • From: "Doug Gernaat" <dag@xxxxxxxxxxxxxxx>
  • To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • Date: Mon, 17 Sep 2007 09:07:26 -0500

no problem... 

i just have two functions in this package that i want to make
available. one returns an integer and the other a string.
i'm getting feedback that it sounds like a good candidate for
a web service. even so... i'm just wondering what options i
might have.


>>> "Niall Litchfield" <niall.litchfield@xxxxxxxxx> 9/17/2007 7:25:44 AM >>>
I'll admit that I got into some of the sidetracks and didn't deal with
your questions. sorry.

you don't provide - probably for perfectly good reasons - a
description of what the code does. Web services work, reasonably, well
for small scale remote invocations of well designed small resultsets
obtained from performant code. They work badly - in my experience -
for large resultsets, for ill designed arbitrary resultsets from
arbitrary code. So for example a webservice that answers the question
"What's the customer address for customer reference 'XXXY123'" will
likely be quite a useful component of a CRM database. One that answers
the question "What was the average length of time customers with names
that sound like smith spent on the phone to our customer service
centre in the last 63.4 days and what products were they asking about
anyway?" (i.e selected from a friendly GUI with a combination of check
and textboxes) will likely perform poorly - but might make a great

On 9/14/07, Doug Gernaat <dag@xxxxxxxxxxxxxxx> 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.
> not sure if this is a web service candidate or what.

Niall Litchfield
Oracle DBA


Other related posts: