Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning data sets from an Oracle Stored Procedure
Message
From
31/01/2000 18:20:02
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325315
Message ID:
00325354
Views:
41
Hmm. It's been years since I've worked with VFP and Oracle. But there must be a mechanism in PL/SQL to return a result set. There has to be, otherwise Oracle would not work too well with front-ends.

>Oracle does not return any thing from a procedure unless it is passed by reference. It is therefore impossible for a cursor to be returned from a stored procedure. SQL pass through of a select statement doesn’t call a stored proc so it will return a cursor.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform