Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Stored Procedures returning records
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00903180
Message ID:
00904178
Views:
18
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
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform