Hi,
First off I would like to mention I have no experience with Oracle. About 5 years ago I had several projects that hit sybase as the backend. But as we all know things have changed since then.:-)

I have an application that I wrote in VFP using remote views(Oracle 8i backend). This application takes the quanity that has run on a web-press for a given shift(Batch)and calculates how much ink was used. It then creates a text file to be imported into the application that manages the press data. The application has always been slow, but now that the data has grown it has become increasingly slow.

I'm thinking I need to do the queries and calculations on the server. Then let it return the data needed for the text file to VFP. But as I try to figure out how to do this I keep getting confused between using an SP or function or a package. I think I need to create a package with procedures and functions but I'm not real sure how to do this.

Any guidance would be greatly appreciated.

Thanks
Bill