Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: publish a pl/sql pkg

Re: publish a pl/sql pkg

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 17 Sep 2007 13:25:44 +0100
Message-ID: <7765c8970709170525x23f0d5a5r271aead973a23f1@mail.gmail.com>


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 report.

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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 17 2007 - 07:25:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US