Skip to content

Instantly share code, notes, and snippets.

@mikebeaton

mikebeaton/mighty2_6.cs

Created September 19, 2019 12:19
Show Gist options
  • Save mikebeaton/eacab2be997e569bf692eb856c1161c4 to your computer and use it in GitHub Desktop.
Save mikebeaton/eacab2be997e569bf692eb856c1161c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mighty2_6.cs
var results = db.ExecuteWithParams("begin open :p_rc for select * from emp where deptno = 10; end;",
outParams: new { p_rc = new Cursor() },
// shared connection (Oracle) or transaction (PostgreSQL) required to share cursors
connection: conn);
db.ExecuteAsProcedure("cursor_in_out.process_cursor",
inParams: new { p_cursor = results.p_rc },
connection: conn);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment