Paige:

Read this entire thread

More specifically, if only calling a SP:

lcSQL = "{call MyStoredProc;}"
lnresult = sqlexec(lnHandle, lcSQL, "crsPermit")


>Hello All,
>
>How would I call an Oracle process or function from VFP? I can use ADO or SOL-Pass Thru to process the Oracle data but I'd like to run an existing Oracle process/fuction to "filter" the dataset first. TIA.
>
>Regards,
>
>Paige