René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Dapper OracleDynamicParameters, multipleQquery and clause 'in'","articleBody":"Hi,\r\nI am struggling with something not sure why not able to execute.\r\n\r\nI have a clause in that I would like to execute in a second query...\r\nfor simplicity let's say something like :\r\n\r\n`\r\n```\r\nbegin\r\n\r\n  open :c_query1 for\r\n    select * from T1;\r\n\r\n  open :c_query2 for\r\n  select * from T2 t_t2 where t_t2.name in :pNames;\r\n\r\nend;\r\n```\r\n`\r\n\r\nwhere I would have my parameters as \r\n`\r\n```\r\n            var dynParams = new OracleDynamicParameters();\r\n            dynParams.Add(\":c_query1\", direction: ParameterDirection.Output, dbType: OracleMappingType.RefCursor);\r\n            dynParams.Add(\":c_query2\", direction: ParameterDirection.Output, dbType: OracleMappingType.RefCursor);\r\n            dynParams.Add(\":pNames\", new[] {\"AA\", \"BB\"});\r\n```\r\n`\r\n\r\nwhen I execute this my \"in clause\" comes empty....\r\nany idea?\r\nthanks\r\n","author":{"url":"https://github.com/figueiredorj","@type":"Person","name":"figueiredorj"},"datePublished":"2021-10-11T17:16:38.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/53/Dapper.Oracle/issues/53"}