Maybe I'm missing something somewhere, but I can't seem to find the answer.
To optimize things, I'd like to do frequent fetches using Oracle stored procedure. There are two parts to this: 1. How do I write the Oracle stored procedure in PL/SQL? What should be returned? According to Tom Kyte, this is how it's done: http://asktom.oracle.com/tkyte/ResultSets/index.html I was able to create the stored procedure that returns a cursor. But I couldn't fetch from EOF? Or should the stored procedure return something other than a cursor? 2. How do I fetch the result set from an Oracle stored procedure into EOF? Ideally, I'd like to fetch the results as EOs, not raw rows. EOUtilities.rawRowsWithQualifierFormat() doesn't like the store procedure that returns a cursor (or maybe I didn't do it correctly?). And if using this approach, then EOUtilities.objectFromRawRow() actually turns the raw rows into faults, resulting yet another trip to the database, which is not desirable. Thanks for your help! ^James P.S. I sent this in December to the Omnigroup WO mailing list, not realizing that there's the Apple WO list (yep, shows my age. :-) No good solution came out of it. Hopefully someone here has done this? _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
