{"action":"opened","issue":{"url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/issues/290","repository_url":"https://api.github.com/repos/K2InformaticsGmbH/dderl","labels_url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/issues/290/labels{/name}","comments_url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/issues/290/comments","events_url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/issues/290/events","html_url":"https://github.com/K2InformaticsGmbH/dderl/issues/290","id":173942329,"number":290,"title":"PL-SQL Scalar Out Bind support  ","user":{"login":"stoch","id":1941407,"avatar_url":"https://avatars.githubusercontent.com/u/1941407?v=3","gravatar_id":"","url":"https://api.github.com/users/stoch","html_url":"https://github.com/stoch","followers_url":"https://api.github.com/users/stoch/followers","following_url":"https://api.github.com/users/stoch/following{/other_user}","gists_url":"https://api.github.com/users/stoch/gists{/gist_id}","starred_url":"https://api.github.com/users/stoch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stoch/subscriptions","organizations_url":"https://api.github.com/users/stoch/orgs","repos_url":"https://api.github.com/users/stoch/repos","events_url":"https://api.github.com/users/stoch/events{/privacy}","received_events_url":"https://api.github.com/users/stoch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"acautin","id":949102,"avatar_url":"https://avatars.githubusercontent.com/u/949102?v=3","gravatar_id":"","url":"https://api.github.com/users/acautin","html_url":"https://github.com/acautin","followers_url":"https://api.github.com/users/acautin/followers","following_url":"https://api.github.com/users/acautin/following{/other_user}","gists_url":"https://api.github.com/users/acautin/gists{/gist_id}","starred_url":"https://api.github.com/users/acautin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acautin/subscriptions","organizations_url":"https://api.github.com/users/acautin/orgs","repos_url":"https://api.github.com/users/acautin/repos","events_url":"https://api.github.com/users/acautin/events{/privacy}","received_events_url":"https://api.github.com/users/acautin/received_events","type":"User","site_admin":false},"assignees":[{"login":"acautin","id":949102,"avatar_url":"https://avatars.githubusercontent.com/u/949102?v=3","gravatar_id":"","url":"https://api.github.com/users/acautin","html_url":"https://github.com/acautin","followers_url":"https://api.github.com/users/acautin/followers","following_url":"https://api.github.com/users/acautin/following{/other_user}","gists_url":"https://api.github.com/users/acautin/gists{/gist_id}","starred_url":"https://api.github.com/users/acautin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acautin/subscriptions","organizations_url":"https://api.github.com/users/acautin/orgs","repos_url":"https://api.github.com/users/acautin/repos","events_url":"https://api.github.com/users/acautin/events{/privacy}","received_events_url":"https://api.github.com/users/acautin/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/milestones/14","html_url":"https://github.com/K2InformaticsGmbH/dderl/milestones/1.6.2","labels_url":"https://api.github.com/repos/K2InformaticsGmbH/dderl/milestones/14/labels","id":1923428,"number":14,"title":"1.6.2","description":"","creator":{"login":"tgdriph3","id":12758474,"avatar_url":"https://avatars.githubusercontent.com/u/12758474?v=3","gravatar_id":"","url":"https://api.github.com/users/tgdriph3","html_url":"https://github.com/tgdriph3","followers_url":"https://api.github.com/users/tgdriph3/followers","following_url":"https://api.github.com/users/tgdriph3/following{/other_user}","gists_url":"https://api.github.com/users/tgdriph3/gists{/gist_id}","starred_url":"https://api.github.com/users/tgdriph3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tgdriph3/subscriptions","organizations_url":"https://api.github.com/users/tgdriph3/orgs","repos_url":"https://api.github.com/users/tgdriph3/repos","events_url":"https://api.github.com/users/tgdriph3/events{/privacy}","received_events_url":"https://api.github.com/users/tgdriph3/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":18,"state":"open","created_at":"2016-08-04T12:21:24Z","updated_at":"2016-08-30T06:49:25Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-08-30T06:49:25Z","updated_at":"2016-08-30T06:49:25Z","closed_at":null,"body":"Anonymous PL-SQL-Blocks can be used to query the database like so:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1941407/18078686/35377102-6e8d-11e6-8e80-10432fd71700.png)\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1941407/18078683/29dd8ac6-6e8d-11e6-861f-bbd27d6b1591.png)\r\n\r\nImprovements:\r\n1) OUT-Parameters contain the substring '\\_OUT\\_' (there could be more than one) should be presented in the bottom of the list (alphabetically sorted separately from other parameters).\r\n \r\n2) OUT-Parameters must be cleared before running the query. This will allocate a big return buffer of 4400 bytes to receive the result for parameter types SQLT_CHR and SQLT_STR. Future OCI drivers will implement dynamic binding which avoids the transport overhead.\r\n\r\nNote: Future extensions of PL-SQL Bind support (not in current scope) will consist of:\r\n* PL_SQL REF Cursor Output Support (one table opened in streaming mode per SQLT_REF or SQLT_CUR Out variable)\r\n* PL_SQL BLOB Output Support (streaming download in fixes size binary blocks of 100 byptes to a temp table)\r\n* PL_SQL CLOB Output Support (streaming download in 100 character blocks to a temp table)\r\n* Export function for CLOB and BLOB which concatenates multiple (or all) rows into a file for download\r\n"}}
{"actor":{"display_login":"stoch"}}