fetch EOs using Oracle stored procedures
fetch EOs using Oracle stored procedures
- Subject: fetch EOs using Oracle stored procedures
- From: "James C. Lee" <email@hidden>
- Date: Thu, 8 Feb 2007 09:50:19 -0800
- Importance: Normal
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden