Re: some hints to understand the plsql cursor.

2019-02-27 Thread Andy Fan
Thanks Kumar. actually I was asking what the the cursor did in the server. By looking the code, looks it cache the previous Portal with the name is the cursor name, whenever we run the fetch from the portal, it will restore the previous Portal and run it. But your minimized and interactive co

Re: some hints to understand the plsql cursor.

2019-02-27 Thread Dilip Kumar
On Wed, Feb 27, 2019 at 4:42 PM Andy Fan wrote: > > actually I'm hacking pg for a function like : > 1. define a select query. > 2. client ask for some data. and server reply some data. server will do > NOTHING if client doesn't ask any more.. > 3. client ask some data more data with a batch and

some hints to understand the plsql cursor.

2019-02-27 Thread Andy Fan
actually I'm hacking pg for a function like : 1. define a select query. 2. client ask for some data. and server reply some data. server will do NOTHING if client doesn't ask any more.. 3. client ask some data more data with a batch and SERVER reply some data then. then do NOTHING. currently the