Hi Mark,
Oracle ODBC Driver vs. MS ODBC Driver for Oracle

The syntax looks right.

>Anyone know why when I try passing variables by reference to an Oracle package using VFP SPT, this error is returned? --
>
>Connectivity error: [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
>PLS-00306: wrong number or types of arguments in call to 'RETURNCURSOR'
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>The VFP code I am using:

>LOCAL lcSQL
>PRIVATE pnCount
>pnCount = 10  && get top N records
>lcSQL = "begin ArticleGetMostPopular.ReturnCursor(nCount=>?pnCount); end;"
>lnRetVal = SQLEXEC(lnHandle, lcSQL, 'crsMostPopular')

>The Oracle package is:

>CREATE OR REPLACE PACKAGE ArticleGetMostPopular AS
> Type RetCursor Is Ref Cursor;
> Procedure ReturnCursor(
>    nCount  IN  number,
>    pCursor OUT RetCursor);
>END;
>/
>show error
>CREATE OR REPLACE PACKAGE BODY ArticleGetMostPopular AS
> Procedure ReturnCursor(
>    nCount  IN  number,
>    pCursor OUT RetCursor) is
> Begin
>  open pCursor for
>    select * FROM
>     (SELECT Article.ID, COUNT(*) AS Count
>      FROM Article, ArticleKeyPhrase
>      WHERE ArticleKeyPhrase.ArticleID = Article.ID
>      GROUP BY Article.ID
>      ORDER BY Count DESC)
>      where ROWNUM <= nCount;
> End;
>END;
>/
>show error
>--
>

>TIA!