Start by doing a little research in this forum. Search for Books and limit your search scope to my UT member ID [12473]. There are several excellent Oracle books I recommend including PL/SQL that explains creating packages and procedures. Next do a search on Packages then Procedures with no member limits. You should find many examples already posted here.

Once you get an idea of what this PL/SQL code looks like, it may help you develop your own SP code where you can come up with more specific questions.

You also need indexes on your Oracle tables on columns that your queries are hitting just as you would in VFP.

>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