From: Rémy G. <rem...@gm...> - 2011-05-20 19:40:38
|
On Wed, Dec 8, 2010 at 10:15 AM, <iv...@cv...> wrote: > > Quoting Rémy Guillemette <rem...@gm...>: > >> On Fri, Nov 26, 2010 at 5:54 AM, <iv...@cv...> wrote: >>> >>> Quoting Rémy Guillemette <rem...@gm...>: >>> >>>> On 11/19/2010 07:46 PM, Ivan Brezina wrote: >>>>> >>>>> I've to disapoint you, this feature is not supported(yet). >>>>> The datatype sys_refcursor represents a table itself >>>>> and fetching fields of datatype cursor are not supported >>>>> neither by OTL nor trotl connection provider. >>>>> >>>>> As far as I know it does not work even in toad nor in SQLDeveloper. >>>>> It only works in sqlplus. >>>> >>>> Thanks Ivan. >>>> >>>> It works with Toad and SQL developer. >>>> Toad display a table with one cell named CURSOR. When you click on it, >>>> a popup is opened with the function's result. >>>> SQL developer shows a string with the cursor's data ( line1 [ >>>> key=value, key1=value2, ] etc...) >>>> >>>> Is it possible to open a request feature somewhere? >>>> >>>> PS : I mess up a little bit the reply. I don't know why but >>>> sourceforge did not send your reply to me. I changed my email address >>>> and I should be able to quote you correctly next time. >>>> >>> >>> I plan to implement it, but I wont not promise anything before Christmas:) > > Hi, > I've commited initial support for cursors returned from select statements. > Tora should handle queries like > select cursor(select 'A', 2 from dual), cursor(select 'B', 22 from dual) from dual; > > Or > SELECT CURSOR(SELECT department_name, location_id FROM HR.departments d where e.department_id=d.department_id) , last_name FROM HR.employees e where rownum < 20; > > At this moment the cursor is converted into a string when fetched from DB. > So you should see TAB delimited string representing a cursor's table. > > This should work for reasonable small resultsets returned by a query. > > Ivan > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > Hi Ivan, I was able to build tora from svn on windows. I tried select cursor(select 'A', 2 from dual) from dual; and I got Unsupported column datatype. These queries are not working as well : select cursor(select ppr_worktest_pck.testpck('hello') from dual) from dual; select CURSOR(ppr_worktest_pck.testpck('hello')) from dual; Thanks for your help. -- Remi Guillemette |