>Now that I have created the package, nothing I try will actually return the cursor from the package. After creating my connection to Oracle, my SQLExec syntax is:
>
>lnresult = sqlexec(lnHandle, lcSQL, "crsPermit")
>
>where lcSQL is defined on each of the SQL Cmd lines below. Each of the 5 variations of the Call SQL produced the following errors:

>*** Test 2 ***
>SQL Cmd: {call GetPermits.ReturnCursor('LA0006335')};
>Error #: 1526
>Msg 1  : Connectivity error: [Microsoft][ODBC driver for
>         Oracle][Oracle]ORA-06550: line 1, column 48:
>         PLS-00103: Encountered the symbol ";" The symbol ";"
>         was ignored.
>Msg 2  : [Microsoft][ODBC driver for Oracle][Oracle]
>         ORA-06550: line 1, column 48:PLS-00103:
>         Encountered the symbol ";" The symbol ";"
>         was ignored.
>Msg 3  : 37000

Mark,
Test 2 should work. How are you assigning the lcSQL variable? Here is my exact assignment line and it returns a cursor.

lcSQL = [{call RCISPackage.ReturnCursor('ZZZZZ')};]

Even if the key doesn't exist, I still get a cursor back.

Also, what version of the Oracle ODBC driver are you using? I've got 8.01.07.00.