Re: an old question
Paul Moore <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CACac1F8sdRvWZCU4mmcNFeXnbN5=g25bRzU0yi0vHsYrt4vjmQ@mail.gmail.com> |
On 18 April 2013 23:48, Glyph <glyph-wgPraSjSqjuEakHPNWoOSQC/[email protected]> wrote: > Thanks for responding, but, unfortunately, no. I put a comment there, but > in short; I know that it's unusual, but there are cases where inline PL/SQL > can do things that regular SQL can't. > > *Is* there any way to emit data back to the application from an inline > block like this? > Can you give an example of your actual code? In general, the answer to your question is "no", because PL/SQL blocks are not select statements and therefore do not return rows via the cursor. But there are ways, depending on the details of what you want to do. Your requirement to not modify the schema (specifically not creating stored procedures) makes it hard, though... Paul ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users