{"action":"created","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/142","repository_url":"https://api.github.com/repos/laurenz/oracle_fdw","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/142/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/142/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/142/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/142","id":201488864,"number":142,"title":"oracle_utils.c:22:17: error: oci.h: No such file or directory","user":{"login":"i-techsolutions","id":13335595,"avatar_url":"https://avatars.githubusercontent.com/u/13335595?v=3","gravatar_id":"","url":"https://api.github.com/users/i-techsolutions","html_url":"https://github.com/i-techsolutions","followers_url":"https://api.github.com/users/i-techsolutions/followers","following_url":"https://api.github.com/users/i-techsolutions/following{/other_user}","gists_url":"https://api.github.com/users/i-techsolutions/gists{/gist_id}","starred_url":"https://api.github.com/users/i-techsolutions/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/i-techsolutions/subscriptions","organizations_url":"https://api.github.com/users/i-techsolutions/orgs","repos_url":"https://api.github.com/users/i-techsolutions/repos","events_url":"https://api.github.com/users/i-techsolutions/events{/privacy}","received_events_url":"https://api.github.com/users/i-techsolutions/received_events","type":"User","site_admin":false},"labels":[{"id":189750464,"url":"https://api.github.com/repos/laurenz/oracle_fdw/labels/problem","name":"problem","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":14,"created_at":"2017-01-18T06:16:03Z","updated_at":"2017-01-18T10:54:04Z","closed_at":null,"body":"Hi,\r\n\r\nI am getting this issue on fresh installation of ORACLE FDW.\r\n\r\nI am able to access my oracle client from the user access.\r\n\r\nHere is my bashrc & bash_profile contents\r\n\r\n```\r\nPATH=$PATH:$HOME/bin:/usr/lib/oracle/11.2/client64:/usr/lib/oracle/11.2/client64/bin:/opt/PostgreSQL/9.3:/opt/PostgreSQL/9.3/bin\r\nexport LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib\r\n  export TNS_ADMIN=/usr/lib/oracle/11.2/client64\r\n  export ORACLE_HOME=/usr/lib/oracle/11.2/client64\r\n\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/comments/273445030","html_url":"https://github.com/laurenz/oracle_fdw/issues/142#issuecomment-273445030","issue_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/142","id":273445030,"user":{"login":"i-techsolutions","id":13335595,"avatar_url":"https://avatars.githubusercontent.com/u/13335595?v=3","gravatar_id":"","url":"https://api.github.com/users/i-techsolutions","html_url":"https://github.com/i-techsolutions","followers_url":"https://api.github.com/users/i-techsolutions/followers","following_url":"https://api.github.com/users/i-techsolutions/following{/other_user}","gists_url":"https://api.github.com/users/i-techsolutions/gists{/gist_id}","starred_url":"https://api.github.com/users/i-techsolutions/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/i-techsolutions/subscriptions","organizations_url":"https://api.github.com/users/i-techsolutions/orgs","repos_url":"https://api.github.com/users/i-techsolutions/repos","events_url":"https://api.github.com/users/i-techsolutions/events{/privacy}","received_events_url":"https://api.github.com/users/i-techsolutions/received_events","type":"User","site_admin":false},"created_at":"2017-01-18T10:54:04Z","updated_at":"2017-01-18T10:54:04Z","body":"Please find response of EXPLAIN\r\n\r\nEXPLAIN SELECT * FROM drcp;\r\nERROR:  Oracle table \"MIS\".\"DRCP\" for foreign table \"drcp\" does not exist or does not allow read access\r\nDETAIL:  ORA-00942: table or view does not exist\r\nHINT:  Oracle table names are case sensitive (normally all uppercase).\r\n"}}
{"actor":{"display_login":"i-techsolutions"}}