{"action":"created","issue":{"url":"https://api.github.com/repos/kubo/ruby-oci8/issues/103","labels_url":"https://api.github.com/repos/kubo/ruby-oci8/issues/103/labels{/name}","comments_url":"https://api.github.com/repos/kubo/ruby-oci8/issues/103/comments","events_url":"https://api.github.com/repos/kubo/ruby-oci8/issues/103/events","html_url":"https://github.com/kubo/ruby-oci8/issues/103","id":111587094,"number":103,"title":"Using bolean bind variables","user":{"login":"GPardal","id":8460939,"avatar_url":"https://avatars.githubusercontent.com/u/8460939?v=3","gravatar_id":"","url":"https://api.github.com/users/GPardal","html_url":"https://github.com/GPardal","followers_url":"https://api.github.com/users/GPardal/followers","following_url":"https://api.github.com/users/GPardal/following{/other_user}","gists_url":"https://api.github.com/users/GPardal/gists{/gist_id}","starred_url":"https://api.github.com/users/GPardal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GPardal/subscriptions","organizations_url":"https://api.github.com/users/GPardal/orgs","repos_url":"https://api.github.com/users/GPardal/repos","events_url":"https://api.github.com/users/GPardal/events{/privacy}","received_events_url":"https://api.github.com/users/GPardal/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-15T10:19:35Z","updated_at":"2015-11-01T12:35:13Z","closed_at":"2015-11-01T12:35:13Z","body":"Hey there,\r\n\r\nI'm trying to use bind variables to get the output of a SQL procedure. However, one of the output variables (:out_result) is a Bolean. I've tried to do something like:\r\n```\r\nout_error_ctl = ' '*4000\r\nout_result = true\r\nquery1 = <<-SQL.gsub(/^\\s*/, '')\r\n      BEGIN\r\n         RetVal := #{db_info[:schema]}.#{db_info[:procedure]}.reload(\r\n                         ....input vars....\r\n                        outerrorctl  => :out_error_ctl,\r\n                        outresult    => :out_result);\r\n      END;\r\n    SQL\r\n\r\n...\r\n@dbh.exec(query1, out_error_ctl, out_result)\r\n```\r\n\r\nThe thing is, the out_result variable in Ruby is a TrueClass, and not a bolean as the PL/SQL accepts it. I get the following error: \r\n\r\nunsupported datatype: TrueClass\r\n\r\nI've been reading the documentation, and found nothing regarding a Bolean type defined by Ruby-Oci8. No searches have returned this use case, and I'm quite lost at what to do. I've even tried to set out_result = ' '*4000 and in the PL/SQL block declaring :out_result BOOLEAN;, but then I get the following error:\r\n\r\nPLS-00103: Encountered the symbol \"\" when expecting one of the following:\r\n\r\nDoes any one have any ideas how to solve this problem?\r\n\r\nThanks for the help."},"comment":{"url":"https://api.github.com/repos/kubo/ruby-oci8/issues/comments/152822937","html_url":"https://github.com/kubo/ruby-oci8/issues/103#issuecomment-152822937","issue_url":"https://api.github.com/repos/kubo/ruby-oci8/issues/103","id":152822937,"user":{"login":"kubo","id":43904,"avatar_url":"https://avatars.githubusercontent.com/u/43904?v=3","gravatar_id":"","url":"https://api.github.com/users/kubo","html_url":"https://github.com/kubo","followers_url":"https://api.github.com/users/kubo/followers","following_url":"https://api.github.com/users/kubo/following{/other_user}","gists_url":"https://api.github.com/users/kubo/gists{/gist_id}","starred_url":"https://api.github.com/users/kubo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kubo/subscriptions","organizations_url":"https://api.github.com/users/kubo/orgs","repos_url":"https://api.github.com/users/kubo/repos","events_url":"https://api.github.com/users/kubo/events{/privacy}","received_events_url":"https://api.github.com/users/kubo/received_events","type":"User","site_admin":false},"created_at":"2015-11-01T12:35:13Z","updated_at":"2015-11-01T12:35:13Z","body":"Ruby-oci8 2.2.1 was released.\r\nIt supports boolean type binding if both Oracle server and client versions are 12c.\r\n"}}