{"action":"opened","issue":{"url":"https://api.github.com/repos/mybatis/mybatis-3/issues/566","labels_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/566/labels{/name}","comments_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/566/comments","events_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/566/events","html_url":"https://github.com/mybatis/mybatis-3/issues/566","id":130026930,"number":566,"title":"Support of nested cursors","user":{"login":"dsulimchuk","id":6117066,"avatar_url":"https://avatars.githubusercontent.com/u/6117066?v=3","gravatar_id":"","url":"https://api.github.com/users/dsulimchuk","html_url":"https://github.com/dsulimchuk","followers_url":"https://api.github.com/users/dsulimchuk/followers","following_url":"https://api.github.com/users/dsulimchuk/following{/other_user}","gists_url":"https://api.github.com/users/dsulimchuk/gists{/gist_id}","starred_url":"https://api.github.com/users/dsulimchuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsulimchuk/subscriptions","organizations_url":"https://api.github.com/users/dsulimchuk/orgs","repos_url":"https://api.github.com/users/dsulimchuk/repos","events_url":"https://api.github.com/users/dsulimchuk/events{/privacy}","received_events_url":"https://api.github.com/users/dsulimchuk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-30T19:25:58Z","updated_at":"2016-01-30T19:25:58Z","closed_at":null,"body":"Hello!\r\nCan myBatis support oracle nested cursors ? [https://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions005.htm](docs)\r\n\r\nfor example i have next select statement:\r\n`\r\n<select id=\"tt\" statementType=\"PREPARED\" resultType=\"hashmap\">\r\nSELECT 1 id\r\n                ,CURSOR (SELECT LEVEL\r\n                    FROM dual\r\n                    CONNECT BY LEVEL &gt;= 5) coll\r\n        FROM dual\r\n    </select>\r\n`\r\nand take a result = {COLL=oracle.jdbc.driver.OracleResultSetImpl@54c75937, ID=1}\r\n\r\nplease add support of evaluating nested cursors\r\n"}}