I am not sure about your SQL. I have not tried it that way. The link to the other UT message has the SP code that needs to exist in the Oracle database. The syntax to call that SP to return a cursor via SQLEXEC() is also part of that message.
Are you trying to do this WITHOUT creating a package/SP on the server?
>So if use the Oracle ODBC Driver my SQLEXEC,
>
>
> lcSQL = 'DECLARE '
> lcSQL = lcSQL + 'TYPE CURSOR_TYPE_1 IS REF CURSOR; '
> lcSQL = lcSQL + 'report_cursor CURSOR_TYPE_1; '
> lcSQL = lcSQL + 'record_0 RFI.GET_TODAY_TEST_PKG.REPORT_RECTYPE; '
> lcSQL = lcSQL + 'BEGIN '
> lcSQL = lcSQL + " get_today_test_proc(report_cursor," + [']+ lcCompany + ['] + ',' + ['] +lcwarehouse + ['] + "); "
> lcSQL = lcSQL + ' END; '
>
> lnRetVal = SQLEXEC(lnHandle, lcSQL,'Todays_View')
>
>
>I should get a cursor called 'Todays_view' with the result set that the
>package and procedure created?
>
>
>And if that doesn't get my cursor what would I have to do to get that data on the VFP side
Mark McCasland
Midlothian, TX USA