{"action":"created","issue":{"url":"https://api.github.com/repos/vrogier/ocilib/issues/178","repository_url":"https://api.github.com/repos/vrogier/ocilib","labels_url":"https://api.github.com/repos/vrogier/ocilib/issues/178/labels{/name}","comments_url":"https://api.github.com/repos/vrogier/ocilib/issues/178/comments","events_url":"https://api.github.com/repos/vrogier/ocilib/issues/178/events","html_url":"https://github.com/vrogier/ocilib/issues/178","id":367067053,"node_id":"MDU6SXNzdWUzNjcwNjcwNTM=","number":178,"title":"Help with using Collections in a stored proc","user":{"login":"J-Gaeta","id":43327717,"node_id":"MDQ6VXNlcjQzMzI3NzE3","avatar_url":"https://avatars1.githubusercontent.com/u/43327717?v=4","gravatar_id":"","url":"https://api.github.com/users/J-Gaeta","html_url":"https://github.com/J-Gaeta","followers_url":"https://api.github.com/users/J-Gaeta/followers","following_url":"https://api.github.com/users/J-Gaeta/following{/other_user}","gists_url":"https://api.github.com/users/J-Gaeta/gists{/gist_id}","starred_url":"https://api.github.com/users/J-Gaeta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/J-Gaeta/subscriptions","organizations_url":"https://api.github.com/users/J-Gaeta/orgs","repos_url":"https://api.github.com/users/J-Gaeta/repos","events_url":"https://api.github.com/users/J-Gaeta/events{/privacy}","received_events_url":"https://api.github.com/users/J-Gaeta/received_events","type":"User","site_admin":false},"labels":[{"id":224044516,"node_id":"MDU6TGFiZWwyMjQwNDQ1MTY=","url":"https://api.github.com/repos/vrogier/ocilib/labels/help%20wanted","name":"help wanted","color":"159818","default":true}],"state":"closed","locked":false,"assignee":{"login":"vrogier","id":5913457,"node_id":"MDQ6VXNlcjU5MTM0NTc=","avatar_url":"https://avatars3.githubusercontent.com/u/5913457?v=4","gravatar_id":"","url":"https://api.github.com/users/vrogier","html_url":"https://github.com/vrogier","followers_url":"https://api.github.com/users/vrogier/followers","following_url":"https://api.github.com/users/vrogier/following{/other_user}","gists_url":"https://api.github.com/users/vrogier/gists{/gist_id}","starred_url":"https://api.github.com/users/vrogier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vrogier/subscriptions","organizations_url":"https://api.github.com/users/vrogier/orgs","repos_url":"https://api.github.com/users/vrogier/repos","events_url":"https://api.github.com/users/vrogier/events{/privacy}","received_events_url":"https://api.github.com/users/vrogier/received_events","type":"User","site_admin":false},"assignees":[{"login":"vrogier","id":5913457,"node_id":"MDQ6VXNlcjU5MTM0NTc=","avatar_url":"https://avatars3.githubusercontent.com/u/5913457?v=4","gravatar_id":"","url":"https://api.github.com/users/vrogier","html_url":"https://github.com/vrogier","followers_url":"https://api.github.com/users/vrogier/followers","following_url":"https://api.github.com/users/vrogier/following{/other_user}","gists_url":"https://api.github.com/users/vrogier/gists{/gist_id}","starred_url":"https://api.github.com/users/vrogier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vrogier/subscriptions","organizations_url":"https://api.github.com/users/vrogier/orgs","repos_url":"https://api.github.com/users/vrogier/repos","events_url":"https://api.github.com/users/vrogier/events{/privacy}","received_events_url":"https://api.github.com/users/vrogier/received_events","type":"User","site_admin":false}],"milestone":null,"comments":21,"created_at":"2018-10-05T05:39:37Z","updated_at":"2018-12-12T05:41:11Z","closed_at":"2018-10-17T08:44:48Z","author_association":"NONE","body":"Hi I have a number of stored procs which contain arrays in the parameters. To make things easier I would like to use a Collection as the parameter.\r\n\r\nI'm a little confused with the structure / use of Collection and I'm getting the following error\r\n\r\n ORA-00931: Missing Identifier\r\n\r\nThis is how I'm declaring it\r\n\r\nCollection<ostring> attribIdArray(TypeInfo(con, \"VARCHAR2\", TypeInfo::Type));\r\n\r\nThe error occurs after I step over this.\r\n\r\nThe collection is for the p_Attrib_Id parameter in the stored proc header below\r\n\r\nThank you for your assistance.\r\n\r\nCheers\r\n\r\nJohn \r\n\r\n  PROCEDURE Modify (\r\n    p_Slot_SUN               IN        wp_domain.TS_Slot_SUN,               --\r\n    p_Slot_Type_Cd              OUT    wp_domain.TS_Slot_Type_Cd,           --\r\n    p_Slot_No                IN OUT    wp_domain.TS_Slot_No,                --\r\n    p_Compnt_Classn_Id       IN        wp_domain.TS_Compnt_Classn_Id,       --\r\n    p_Slot_Status_Cd         IN OUT    wp_domain.TS_Slot_Status_Cd,         --\r\n    p_Slot_Alias             IN OUT    wp_domain.TS_Slot_Alias,             --\r\n    p_Dest_Label_Tx          IN        wp_domain.TS_Dest_Label_Tx,          --\r\n    p_Slot_SysLock              OUT    wp_domain.TS_SysLock,                --\r\n    p_Site_SUN               IN        wp_domain.TS_Site_SUN,               --\r\n    p_Parent_Slot_SUN        IN        wp_domain.TS_Parent_Slot_SUN,        --\r\n    p_Recursive              IN OUT    VARCHAR2,                            -- ?????\r\n    p_row_status_cd          IN        wp_domain.TS_Row_status_cd,          -- Deprecated. Always set to constant value as specified in wp_constant\r\n    p_Ntwrk_Point_SUN        IN        wp_domain.TS_Ntwrk_Point_SUN,        -- The reference to the spatial point for the slot\r\n    p_Mapping_Symbol_Cd      IN        wp_domain.TS_Mapping_Symbol_Cd,      --\r\n    p_Symbol_Rotn_Val        IN        wp_domain.TS_Symbol_Rotn_Val,        --\r\n    p_Asmbly_Templt_SUN      IN        wp_domain.TS_Asmbly_Templt_SUN,      -- The reference to the template that was used to creat the slot\r\n    p_Reason_Code_Val        IN        wp_domain.TEvent_Reason_Code_Val,    -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Event_Dt               IN OUT    wp_domain.TEvent_Event_Dt,           -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Event_Note_Tx          IN        wp_domain.TEvent_Event_Note_Tx,      -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Event_SUN                 OUT    wp_domain.TEvent_Event_SUN,          -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Event_Syslock             OUT    wp_domain.TEvent_Syslock,            -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Works_Order_Id         IN        wp_domain.TWOrder_works_order_id,    -- Deprecated by NFM 1.6 prop_change mechanism\r\n    p_Plant_Item_Id          IN        wp_domain.TPl_Plant_Item_Id,         -- The plant item to be installed in the slot\r\n    p_Spec_SUN               IN        wp_domain.TSP_Spec_SUN,              -- The spec to be installed in the slot\r\n    p_Spec_Changed           IN        VARCHAR2,\r\n    p_Slot_Normal_Swtchd_Sts IN        wp_domain.TS_Slot_Normal_Swtchd_Sts, --\r\n    p_Display_Seq_No         IN        NUMBER,                              --\r\n    p_Attrib_Ct              IN        NUMBER,                              -- The number of attributes in the array\r\n    p_Attrib_Id              IN        NFM_Mntatts.Tbl_Attrib_Id,           --\r\n    p_Attrib_Val             IN        NFM_Mntatts.Tbl_Attrib_Val,          --\r\n    p_Compnt_Attrib_Sun      IN        NFM_Mntatts.Tbl_Compnt_Attrib_SUN,\r\n    p_LCC_Code               IN        VARCHAR2,\r\n    p_Install_Date           IN        DATE,\r\n    p_Install_Date_Override  IN        VARCHAR2\r\n  );\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/vrogier/ocilib/issues/comments/446468993","html_url":"https://github.com/vrogier/ocilib/issues/178#issuecomment-446468993","issue_url":"https://api.github.com/repos/vrogier/ocilib/issues/178","id":446468993,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NjQ2ODk5Mw==","user":{"login":"J-Gaeta","id":43327717,"node_id":"MDQ6VXNlcjQzMzI3NzE3","avatar_url":"https://avatars1.githubusercontent.com/u/43327717?v=4","gravatar_id":"","url":"https://api.github.com/users/J-Gaeta","html_url":"https://github.com/J-Gaeta","followers_url":"https://api.github.com/users/J-Gaeta/followers","following_url":"https://api.github.com/users/J-Gaeta/following{/other_user}","gists_url":"https://api.github.com/users/J-Gaeta/gists{/gist_id}","starred_url":"https://api.github.com/users/J-Gaeta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/J-Gaeta/subscriptions","organizations_url":"https://api.github.com/users/J-Gaeta/orgs","repos_url":"https://api.github.com/users/J-Gaeta/repos","events_url":"https://api.github.com/users/J-Gaeta/events{/privacy}","received_events_url":"https://api.github.com/users/J-Gaeta/received_events","type":"User","site_admin":false},"created_at":"2018-12-12T05:41:11Z","updated_at":"2018-12-12T05:41:11Z","author_association":"NONE","body":"Thanks, that makes sense.\r\n\r\nI will try again\r\n\r\nRegards\r\n\r\nJohn\r\n\r\nFrom: Vincent Rogier [mailto:notifications@github.com]\r\nSent: Wednesday, 12 December 2018 3:39 PM\r\nTo: vrogier/ocilib\r\nCc: GAETA John (SPARQ); Author\r\nSubject: Re: [vrogier/ocilib] Help with using Collections in a stored proc (#178)\r\n\r\nHi,\r\n\r\nI've forgotten the keyword 'inline' on the 2 newly added methods in\r\nprevious commit.\r\nI've just committed the change on the 4.6.1 branch.\r\nGet again ocilib_impl.hpp file.\r\n\r\nRegards\r\n\r\n\r\nVincent\r\n\r\n\r\n—\r\nYou are receiving this because you authored the thread.\r\nReply to this email directly, view it on GitHub<https://github.com/vrogier/ocilib/issues/178#issuecomment-446468714>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ApUg5VrwdWAnmHGlNYgIKmW0xWRW854eks5u4JaRgaJpZM4XJll1>.\r\n\r\n\r\n\r\n\r\nTo report this email as spam, please forward to asa@websense.com\r\n\r\n\r\n\r\n \r\n*************************************************************************************\r\nThis email message (including any file attachments transmitted with it) is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, alteration, disclosure or distribution of this email (including any attachments) by an unintended recipient is prohibited. If you have received this email in error, please notify the sender by return email and destroy all copies of the original message. Any confidential or legal professional privilege is not waived or lost by any mistaken delivery of the email. Energy Queensland Limited accepts no responsibility for the content of any email which is sent by an employee which is of a personal nature.\r\n\r\nSender Details:\r\n  Energy Queensland Limited\r\n  Level 6, 420 Flinders Street Townsville QLD 4810\r\n  (07) 4766 2900 \r\n\r\nEnergy Queensland Limited policy is to not send unsolicited electronic messages. Suspected breaches of this policy can be reported by replying to this message including the original message and the word \"UNSUBSCRIBE\" in the subject. \r\n*************************************************************************************\r\n"}}
{"actor":{"display_login":"J-Gaeta"}}