{"action":"created","issue":{"url":"https://api.github.com/repos/rana/ora/issues/19","labels_url":"https://api.github.com/repos/rana/ora/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/rana/ora/issues/19/comments","events_url":"https://api.github.com/repos/rana/ora/issues/19/events","html_url":"https://github.com/rana/ora/issues/19","id":83619334,"number":19,"title":"[Enhancement] for associative arrays parameters in store procedures","user":{"login":"jmptrader","id":580082,"avatar_url":"https://avatars.githubusercontent.com/u/580082?v=3","gravatar_id":"","url":"https://api.github.com/users/jmptrader","html_url":"https://github.com/jmptrader","followers_url":"https://api.github.com/users/jmptrader/followers","following_url":"https://api.github.com/users/jmptrader/following{/other_user}","gists_url":"https://api.github.com/users/jmptrader/gists{/gist_id}","starred_url":"https://api.github.com/users/jmptrader/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmptrader/subscriptions","organizations_url":"https://api.github.com/users/jmptrader/orgs","repos_url":"https://api.github.com/users/jmptrader/repos","events_url":"https://api.github.com/users/jmptrader/events{/privacy}","received_events_url":"https://api.github.com/users/jmptrader/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-06-01T17:44:16Z","updated_at":"2015-06-06T17:53:35Z","closed_at":null,"body":"Dear,\r\n\r\nGreat and very cool package.\r\n\r\nYour library will support Associative Arrays for store procedures. \r\n\r\nIn my case, I have many procedures like this:\r\n\r\nCREATE OR REPLACE PACKAGE testuser.test_pkg IS\r\n\r\n   TYPE assoc_array_varchar2_t IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;\r\n\r\n   PROCEDURE your_proc(p_parm IN assoc_array_varchar2_t);\r\n\r\nEND test_pkg;\r\n\r\nCREATE OR REPLACE PACKAGE BODY testuser.test_pkg IS\r\n\r\n   PROCEDURE your_proc(p_parm IN assoc_array_varchar2_t) AS\r\n   BEGIN\r\n      FOR i IN p_parm.first .. p_parm.last\r\n      LOOP\r\n         dbms_output.put_line(p_parm(i));\r\n      END LOOP;\r\n\r\n   END;\r\n\r\nEND test_pkg;\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/rana/ora/issues/comments/109625502","html_url":"https://github.com/rana/ora/issues/19#issuecomment-109625502","issue_url":"https://api.github.com/repos/rana/ora/issues/19","id":109625502,"user":{"login":"jmptrader","id":580082,"avatar_url":"https://avatars.githubusercontent.com/u/580082?v=3","gravatar_id":"","url":"https://api.github.com/users/jmptrader","html_url":"https://github.com/jmptrader","followers_url":"https://api.github.com/users/jmptrader/followers","following_url":"https://api.github.com/users/jmptrader/following{/other_user}","gists_url":"https://api.github.com/users/jmptrader/gists{/gist_id}","starred_url":"https://api.github.com/users/jmptrader/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmptrader/subscriptions","organizations_url":"https://api.github.com/users/jmptrader/orgs","repos_url":"https://api.github.com/users/jmptrader/repos","events_url":"https://api.github.com/users/jmptrader/events{/privacy}","received_events_url":"https://api.github.com/users/jmptrader/received_events","type":"User","site_admin":false},"created_at":"2015-06-06T17:53:34Z","updated_at":"2015-06-06T17:53:34Z","body":"Tamás; Thanks, i will check this."}}