{"action":"created","issue":{"url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/16","repository_url":"https://api.github.com/repos/pythian/DBD-Oracle","labels_url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/16/comments","events_url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/16/events","html_url":"https://github.com/pythian/DBD-Oracle/issues/16","id":33985931,"number":16,"title":"OCI-21500: internal error code","user":{"login":"lemrouch","id":7658369,"avatar_url":"https://avatars.githubusercontent.com/u/7658369?v=3","gravatar_id":"","url":"https://api.github.com/users/lemrouch","html_url":"https://github.com/lemrouch","followers_url":"https://api.github.com/users/lemrouch/followers","following_url":"https://api.github.com/users/lemrouch/following{/other_user}","gists_url":"https://api.github.com/users/lemrouch/gists{/gist_id}","starred_url":"https://api.github.com/users/lemrouch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lemrouch/subscriptions","organizations_url":"https://api.github.com/users/lemrouch/orgs","repos_url":"https://api.github.com/users/lemrouch/repos","events_url":"https://api.github.com/users/lemrouch/events{/privacy}","received_events_url":"https://api.github.com/users/lemrouch/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2014-05-21T14:12:43Z","updated_at":"2016-07-01T09:06:22Z","closed_at":null,"body":"Hi,\r\nwe have encountered\r\nOCI-21500: internal error code, arguments: [kodrsobj1], [], [], [], [], [], [], []\r\nwhen using DBD::Oracle.\r\n\r\nSteps to reproduce:\r\na) create types and data:\r\nCREATE OR REPLACE TYPE parent_type AUTHID CURRENT_USER AS OBJECT (\r\n    id              NUMBER(38)\r\n) NOT FINAL NOT INSTANTIABLE;\r\n/\r\n\r\nCREATE OR REPLACE TYPE subtype_a AUTHID CURRENT_USER UNDER parent_type (\r\n);\r\n/\r\n\r\nCREATE OR REPLACE TYPE subtype_b AUTHID CURRENT_USER UNDER parent_type (\r\n);\r\n/\r\n\r\nCREATE TABLE t_parents (\r\n    parent          parent_type\r\n);\r\n\r\nINSERT INTO t_parents VALUES (subtype_a(1));\r\nINSERT INTO t_parents VALUES (NULL);\r\nINSERT INTO t_parents VALUES (subtype_b(2));\r\n\r\nCOMMIT;\r\n/\r\n\r\nb) run perl script:\r\nuse DBI;\r\nuse DBD::Oracle qw(:ora_types);\r\n\r\nmy $dbh = DBI->connect(\r\n    \"dbi:Oracle:your_sid\",\r\n    \"username\",\r\n    \"password\"\r\n);\r\n\r\nmy $sth = $dbh->prepare(\" SELECT * FROM t_parents \");\r\n$sth->execute();\r\n\r\nwhile (my @r = $sth->fetchrow_array) {\r\n}\r\n\r\n$dbh->disconnect;\r\n\r\nYou should get:\r\nErrors in file :\r\nOCI-21500: internal error code, arguments: [kodrsobj1], [], [], [], [], [], [], []\r\n..some nonsense..\r\nerror code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] (DBD ERROR: OCIStmtFetch) [for Statement \" SELECT * FROM t_parents \"] at oci_replicate.pl line 13.\r\n\r\nOur Perl is 5.18.2, DBD::Oracle 1.68 (1.74 fails as well)."},"comment":{"url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/comments/229896699","html_url":"https://github.com/pythian/DBD-Oracle/issues/16#issuecomment-229896699","issue_url":"https://api.github.com/repos/pythian/DBD-Oracle/issues/16","id":229896699,"user":{"login":"lemrouch","id":7658369,"avatar_url":"https://avatars.githubusercontent.com/u/7658369?v=3","gravatar_id":"","url":"https://api.github.com/users/lemrouch","html_url":"https://github.com/lemrouch","followers_url":"https://api.github.com/users/lemrouch/followers","following_url":"https://api.github.com/users/lemrouch/following{/other_user}","gists_url":"https://api.github.com/users/lemrouch/gists{/gist_id}","starred_url":"https://api.github.com/users/lemrouch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lemrouch/subscriptions","organizations_url":"https://api.github.com/users/lemrouch/orgs","repos_url":"https://api.github.com/users/lemrouch/repos","events_url":"https://api.github.com/users/lemrouch/events{/privacy}","received_events_url":"https://api.github.com/users/lemrouch/received_events","type":"User","site_admin":false},"created_at":"2016-07-01T09:06:22Z","updated_at":"2016-07-01T09:06:22Z","body":"Hi,\r\nreport from Oracle support:\r\nDev team has marked the Bug as Not a Bug with the following analysis and conclusion. \r\n...\r\nThe issue is when doing OCIDefineObject:\r\npgvpp is defined array of\r\n.\r\ntypedef struct parent_type {\r\nOCINumber id;\r\n}parent_type;\r\n.\r\nWith inheritance we cannot use plain structure to do OCIDefineObject We have to do call OCIObjectNew with correct TDO and not use inline structure. Old demos may have it as at that time there was no inheritance support.\r\n\r\nI guess DBD::Oracle uses the \"old demos\" way, doesn't it?"}}
{"actor":{"display_login":"lemrouch"}}