{"action":"created","issue":{"url":"https://api.github.com/repos/yajra/laravel-oci8/issues/108","labels_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/108/labels{/name}","comments_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/108/comments","events_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/108/events","html_url":"https://github.com/yajra/laravel-oci8/issues/108","id":118011753,"number":108,"title":"Infinite loop when using query builder","user":{"login":"pavlik1510","id":5481640,"avatar_url":"https://avatars.githubusercontent.com/u/5481640?v=3","gravatar_id":"","url":"https://api.github.com/users/pavlik1510","html_url":"https://github.com/pavlik1510","followers_url":"https://api.github.com/users/pavlik1510/followers","following_url":"https://api.github.com/users/pavlik1510/following{/other_user}","gists_url":"https://api.github.com/users/pavlik1510/gists{/gist_id}","starred_url":"https://api.github.com/users/pavlik1510/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pavlik1510/subscriptions","organizations_url":"https://api.github.com/users/pavlik1510/orgs","repos_url":"https://api.github.com/users/pavlik1510/repos","events_url":"https://api.github.com/users/pavlik1510/events{/privacy}","received_events_url":"https://api.github.com/users/pavlik1510/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-20T10:36:02Z","updated_at":"2015-11-20T15:42:53Z","closed_at":null,"body":"Hi,\r\n\r\nfirst thanks for great job on that. I found out when i have a user which is not owner of shema and i have to use a prefix of another Table tan i get Infinite loop.\r\n\r\nI used conection like that :   \r\n      'oracle' => array(\r\n            'driver'   => 'oracle',\r\n            'database' => 'seerver',\r\n            'username' => 'Username',\r\n            'password' => 'password',\r\n            'prefix'   => 'OTHER_SCHEMA.',\r\n        ),\r\n\r\n\r\nafter prefix the application run in the loop. \r\nThe fix was \r\nApp::before(function($request) {\r\n    DB::statement(\"ALTER SESSION SET CURRENT_SCHEMA = other_schema\");\r\n});\r\n\r\n\r\nis there any solution on that?\r\n\r\n\r\nThank you.\r\nBest Regards\r\nPaul"},"comment":{"url":"https://api.github.com/repos/yajra/laravel-oci8/issues/comments/158436783","html_url":"https://github.com/yajra/laravel-oci8/issues/108#issuecomment-158436783","issue_url":"https://api.github.com/repos/yajra/laravel-oci8/issues/108","id":158436783,"user":{"login":"fabiothomaz","id":795025,"avatar_url":"https://avatars.githubusercontent.com/u/795025?v=3","gravatar_id":"","url":"https://api.github.com/users/fabiothomaz","html_url":"https://github.com/fabiothomaz","followers_url":"https://api.github.com/users/fabiothomaz/followers","following_url":"https://api.github.com/users/fabiothomaz/following{/other_user}","gists_url":"https://api.github.com/users/fabiothomaz/gists{/gist_id}","starred_url":"https://api.github.com/users/fabiothomaz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fabiothomaz/subscriptions","organizations_url":"https://api.github.com/users/fabiothomaz/orgs","repos_url":"https://api.github.com/users/fabiothomaz/repos","events_url":"https://api.github.com/users/fabiothomaz/events{/privacy}","received_events_url":"https://api.github.com/users/fabiothomaz/received_events","type":"User","site_admin":false},"created_at":"2015-11-20T15:42:53Z","updated_at":"2015-11-20T15:42:53Z","body":"Paul,\r\n\r\nTry to use the 'schema' attribute in database config:\r\n\r\n'oracle' => array(\r\n'driver' => 'oracle',\r\n'database' => 'seerver',\r\n'username' => 'Username',\r\n'password' => 'password',\r\n'schema' => 'OTHER_SCHEMA',\r\n),"}}