{"action":"created","issue":{"url":"https://api.github.com/repos/yajra/laravel-oci8/issues/452","repository_url":"https://api.github.com/repos/yajra/laravel-oci8","labels_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/452/labels{/name}","comments_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/452/comments","events_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/452/events","html_url":"https://github.com/yajra/laravel-oci8/issues/452","id":350353820,"node_id":"MDU6SXNzdWUzNTAzNTM4MjA=","number":452,"title":"Execute stored procedure with multiple cursors","user":{"login":"enghelewa","id":939234,"node_id":"MDQ6VXNlcjkzOTIzNA==","avatar_url":"https://avatars0.githubusercontent.com/u/939234?v=4","gravatar_id":"","url":"https://api.github.com/users/enghelewa","html_url":"https://github.com/enghelewa","followers_url":"https://api.github.com/users/enghelewa/followers","following_url":"https://api.github.com/users/enghelewa/following{/other_user}","gists_url":"https://api.github.com/users/enghelewa/gists{/gist_id}","starred_url":"https://api.github.com/users/enghelewa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/enghelewa/subscriptions","organizations_url":"https://api.github.com/users/enghelewa/orgs","repos_url":"https://api.github.com/users/enghelewa/repos","events_url":"https://api.github.com/users/enghelewa/events{/privacy}","received_events_url":"https://api.github.com/users/enghelewa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-14T09:42:06Z","updated_at":"2018-08-15T01:10:52Z","closed_at":null,"author_association":"NONE","body":"### Summary of problem or feature request\r\n\r\nI have a stored procedures with more than one cursor two or even more and wonder how could I execute such a stored procedure?\r\n```\r\nprocedure MyProcedure(p1 in number, p2 out number,\r\nrecords1 out sys_refcursor,records2 out sys_refcursor);\r\n```\r\n\r\n### Code snippet of problem\r\n\r\nThe problem is that the available functionality from this package is to execute procedure with only one cursor.\r\n\r\n```\r\npublic function executeProcedureWithCursor($procedureName,\r\narray $bindings = [], $cursorName = ':cursor'){\r\n.....\r\n}\r\n```\r\n\r\n\r\n- Windows 10 pro\r\n- PHP 7.1\r\n- Laravel 5.6.33\r\n- Laravel-OCI8 5.6.*\r\n"},"comment":{"url":"https://api.github.com/repos/yajra/laravel-oci8/issues/comments/413064150","html_url":"https://github.com/yajra/laravel-oci8/issues/452#issuecomment-413064150","issue_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/452","id":413064150,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMzA2NDE1MA==","user":{"login":"yajra","id":2687997,"node_id":"MDQ6VXNlcjI2ODc5OTc=","avatar_url":"https://avatars3.githubusercontent.com/u/2687997?v=4","gravatar_id":"","url":"https://api.github.com/users/yajra","html_url":"https://github.com/yajra","followers_url":"https://api.github.com/users/yajra/followers","following_url":"https://api.github.com/users/yajra/following{/other_user}","gists_url":"https://api.github.com/users/yajra/gists{/gist_id}","starred_url":"https://api.github.com/users/yajra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yajra/subscriptions","organizations_url":"https://api.github.com/users/yajra/orgs","repos_url":"https://api.github.com/users/yajra/repos","events_url":"https://api.github.com/users/yajra/events{/privacy}","received_events_url":"https://api.github.com/users/yajra/received_events","type":"User","site_admin":false},"created_at":"2018-08-15T01:10:52Z","updated_at":"2018-08-15T01:10:52Z","author_association":"OWNER","body":"Try executing it manually. See https://yajrabox.com/docs/laravel-oci8/master/stored-procedure for ref. Thanks!"}}
{"actor":{"display_login":"yajra"}}