Across ODBC or OLEDB?!? No way... But if you have access to Oracle server and you have write own function...

//----------------------------------------
// ORACLE PART
//----------------------------------------
DROP TYPE VT11_T
/
DROP TYPE VT11_O
/

CREATE OR REPLACE TYPE VT11_O IS OBJECT
 (appconfig_pk INT,  config_description VARCHAR2(50),  config_value VARCHAR2(150))
/
CREATE OR REPLACE TYPE VT11_T AS TABLE OF VT11_O
/

CREATE OR REPLACE FUNCTION Victor_test11
RETURN VT11_T
AS
 loBaseTree VT11_T;
BEGIN
  Select VT11_O(appconfig_pk, config_description,  config_value)
      BULK COLLECT INTO loBaseTree
    FROM appconfig
    ORDER BY appconfig_pk;
 RETURN loBaseTree;

EXCEPTION
 WHEN OTHERS THEN
 loBaseTree.DELETE;
 RETURN loBaseTree;
END;
/
SELECT * FROM TABLE(Victor_test11)
/

*----------------------------------------
* VFP PART
*----------------------------------------
=SQLEXEC(handle,"SELECT * FROM TABLE(Victor_test11)")

MartinaJ

>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.