Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Pro*C

Re: Problem with Pro*C

From: Manh-Hoa Le <at770_at_FreeNet.Carleton.CA>
Date: 1997/06/12
Message-ID: <5nove3$9hd@freenet-news.carleton.ca>#1/1

Balaji.S (stmbas_at_lgeds.lg.co.kr) writes:
> Hi,
> I am a newbie to Pro*C.
> I am having problems with Pro*C. I am using varchar variables in a loop
> and fetching records into those variables from a cursor. I am writing
> these variables to a text file for archival purposes. In-spite of NULL
> terminating these varchar variables, I find that in subsequent retrievals
> the old value contained in the varchar variable mix up with the newly
> fetched ones. variablename.arr will have both the old and the new values
> mixed up. Is there something very important i am missing.

  You have to :

  1. before a query, initialize variablename.len to zero.
  2. after a query, use variablename.len to null-terminate the variablename.arr.

  Hope this help. Received on Thu Jun 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US