>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.
BINGO! I was using the Microsoft ODBC Driver for Oracle. BUG!!!!!!!!! I changed to the Oracle driver, and it's a miracle! Thanks for the help.
Mark McCasland
Midlothian, TX USA