Skip to content

Instantly share code, notes, and snippets.

@mikebeaton
Created September 3, 2019 15:12
Show Gist options
  • Select an option

  • Save mikebeaton/af407d34242618fdfdabaeae2278f3de to your computer and use it in GitHub Desktop.

Select an option

Save mikebeaton/af407d34242618fdfdabaeae2278f3de to your computer and use it in GitHub Desktop.
Mighty article: Passing a cursor parameter between calls in Mighty
// passing a cursor parameter between calls in Mighty
var res1 = db.ExecuteWithParams(
"begin open :p_rc for select * from emp " +
"where deptno = 10; end;",
outParams: new { p_rc = new Cursor() },
connection: conn);
db.ExecuteProcedure(
"cursor_in_out.process_cursor",
inParams: new { p_cursor = res1.p_rc },
connection: conn);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment