Re: an old question
Christopher Jones <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
On 04/18/2013 03:48 PM, Glyph wrote: > > On Apr 18, 2013, at 3:12 PM, Mark Harrison <[email protected] <mailto:[email protected]>> 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 -- [email protected] http://twitter.com/ghrd Newly updated, free PHP & Oracle book: http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html ------------------------------------------------------------------------------ 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