Re: [cx-oracle-users] an old question

[Glyph <gl...@tw...>]

On Apr 29, 2013, at 1:00 PM, Paul Moore <p.f...@gm...> wrote:

> OK, got you. (BTW, sorry for the delay in responding, your mail only just arrived on the list).

Yeah, a couple of outgoing mails got stuck.  Sorry!

> I don't think this is possible. DELETE RETURNING is a PL/SQL construct which gives you the deleted rows back as  a collection. You *might* be able to put those into a refcursor somehow, but frankly I can't think of a way that doesn't need you to create a stored procedure/function in the database. If you can do that, a pipelined function would probably give you what you need. (Someone else posted an example elsewhere in the thread that you could probably get to work).

Backing off from "delete returning" for a moment; what is the implicit "output" cursor called from an inline PL/SQL statement?  If I knew that, I could at least try stuffing some rows into it.  Is it just inaccessible from PL/SQL?

-glyph