I am having a problem figuring out how to call an Oracle stored procedure from VFP - and I've been stuck on this for 2 days now - really driving me nuts as this should be something very simple.

Here is my stored proc:

CREATE OR REPLACE PROCEDURE KPOPS.Victor_test10 (p_recordset out Types.cursor_type) AS

BEGIN
Open p_recordset FOR
Select appconfig_pk,
config_description,
config_value
FROM appconfig
ORDER BY appconfig_pk;

END Victor_test10;


I have a "package" called TYPES that has this in it (for the cursor data type)

CREATE OR REPLACE PACKAGE KPOPS.victor_test_package1 IS
type test_type_name is ref cursor return appconfig%rowtype;
END victor_test_package1;


....If I goto to SQL PLUS and run this it works:

>variable c refcursor
>exec kpops.victor_test10(:C)

So HOW THE HELL do I run this stupid thing from VFP ? Nothing I've seen works.