Thread

1. Reading from a REFCURSOR in a C language function

   Vlad Arkhipov <arhipov@dc.baikal.ru> — 2011-04-05T07:24:36Z

   Hi,
   
   I'm trying to write a C language function that has a REFCURSOR argument. 
   Could anyone please give me an example of reading from a cursor in C code?
   
   

2. Re: Reading from a REFCURSOR in a C language function

   Jan Wieck <janwieck@yahoo.com> — 2011-04-05T17:06:09Z

   On 4/5/2011 3:24 AM, Vlad Arkhipov wrote:
   > Hi,
   >
   > I'm trying to write a C language function that has a REFCURSOR argument.
   > Could anyone please give me an example of reading from a cursor in C code?
   >
   
   Sorry, I don't have a code example.
   
   A refcursor data type is basically a string, containing the name of an 
   open cursor (portal). It is stored binary compatible to the text data 
   type. In the C function, you extract that name (using the textout 
   function) and use it inside the FETCH query as the cursor name. You may 
   need to double-quote that string.
   
   
   Jan
   
   -- 
   Anyone who trades liberty for security deserves neither
   liberty nor security. -- Benjamin Franklin
   
   

3. Re: Reading from a REFCURSOR in a C language function

   Vlad Arkhipov <arhipov@dc.baikal.ru> — 2011-04-06T05:31:06Z

   06.04.2011 02:06, Jan Wieck wrote:
   > On 4/5/2011 3:24 AM, Vlad Arkhipov wrote:
   >> Hi,
   >>
   >> I'm trying to write a C language function that has a REFCURSOR argument.
   >> Could anyone please give me an example of reading from a cursor in C 
   >> code?
   >>
   >
   > Sorry, I don't have a code example.
   >
   > A refcursor data type is basically a string, containing the name of an 
   > open cursor (portal). It is stored binary compatible to the text data 
   > type. In the C function, you extract that name (using the textout 
   > function) and use it inside the FETCH query as the cursor name. You 
   > may need to double-quote that string.
   >
   >
   > Jan
   >
   Thanks for the hint. It works great.