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

[Christopher J. <chr...@or...>]

On 04/18/2013 03:48 PM, Glyph wrote:
>
> On Apr 18, 2013, at 3:12 PM, Mark Harrison <mh...@pi... <mailto:mh...@pi...>> wrote:
>
>> On 4/18/13 2:51 PM, Glyph wrote:
>>> Hello fellow cx_Oracle'ers:
>>>
>>> I asked what I thought was a very simple question on Stack Overflow about a year and a half ago, but it still doesn't have an answer.
>>>
>>> In short: how do I get any results out of inline PL/SQL?
>>>
>>> <http://stackoverflow.com/questions/7843551/how-do-i-retrieve-data-from-oracle-as-a-query-result-using-an-anonymous-pl-sql-b>
>>>
>>> If anyone would like to answer the question, either here or there, I'd still appreciate it.
>>
>> I've typed in an answer... let me know if it is useful!
>
> 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?
>

Does PL/SQL's PIPE ROW functionality fit your use case?
See http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/tuning.htm#BABDGCDH

Chris

-- 
chr...@or...  http://twitter.com/ghrd
Newly updated, free PHP & Oracle book:
http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html