Greetings, My main driver here is to allow the creation of Holdable portals at the protocol level for drivers. Currently the only way to create a holdable cursor is at the SQL level.
DECLARE liahona CURSOR WITH HOLD FOR SELECT * FROM films; The JDBC driver has an option in the API to have result sets survive commits see https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html#createStatement-int-int-int- Doing this at the protocol level is the correct way to do this as modifying the SQL to create a cursor is very cumbersome and we already have existing code to create a portal. Adding the ability to specify options Looking for feedback. Dave Cramer
0001-wip-holdable-portals.patch
Description: Binary data
