Re: an old question
Glyph <glyph-wgPraSjSqjuEakHPNWoOSQC/[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
On Apr 29, 2013, at 1:00 PM, Paul Moore <[email protected]> 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 ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users