I'd do it in PL/SQL almost certainly. however if granting you the sql*plus
tool was a problem I forsee some difficulty in persuading IT to grant you an
Oracle schema and create procedure rights. I guess the queston in the end is
how does your organisation do this sort of development and then follow those
channels.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Wayne McDermott" <elhombre_at_bigpond.com> wrote in message
news:AHle8.2250$25.9196_at_newsfeeds.bigpond.com...
> I have developed an inventory control application in MS Access & VBA that
> has been instrumental in saving my company $6 million so far, with at
least
> another 4 to 5 million over the next 18 months. We are a processing plant
> and part of a global group of mining companies. My tool has sparked
interest
> across the group and I am about to release an evaluation copy to other
> sites. Our corporation is in the process of aggressively standardising on
> SAP (and I extract the data from our SAP system)with Oracle of various
> flavours being the underlying DB as far as I can tell.
>
> Access is a superb prototyping tool and an excellent standalone platform,
> however I am considering something rather more professional. For example,
to
> generate the statistical data for 23,000 items with 50 months consumption
in
> VBA takes about 45 minutes, tests indicate the same can be done in C++ in
> under a minute and the last time I used PL/SQL to calculate Single
> Exponentially Smooothed Forecasts for the same data set it was done in a
> matter of seconds.
>
> I have a little Oracle knowledge and have Oracle Enterprise Edition
Release
> 2 V8.1.6 on my home machine (thankyou Oracle!), I had been studying for
> certification but dropped it in favour of a B.Comp Sc which I have
commenced
> this year. And now to the question.
>
> What would be the best way to proceed? Learn enough PL/SQL to write the
> statistical and forecasting engine and use Java to develop a front end? Or
> C++ and Java? Or <cough> Access and <shudder> ODBC? All of this of course
> would depend on me convincing our corporate IT department to letting me
> write an application that digs under SAP, (I know when I first asked for
> access to SQLplus to get to our data under SAP it felt like I had offered
to
> buy the IT managers daughter).
>
> Looking forward to hearing what real Developers/Analysts would do ( I am
but
> a humble storeman).
>
>
>
>
>
>
Received on Sat Mar 02 2002 - 12:30:21 CST
