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

[Paul M. <p.f...@gm...>]

On 18 April 2013 23:48, Glyph <gl...@tw...> 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