RE: Urgent : Problems with Pro*C Code

I have never worked on the regular databases. What I recall is that when I used to fetch a record from my own database, I used to initialize each variable of the structure. The programs I wrote used Direct Memory Access.

Reason for Garbage:
The whole record would have garbage when a pointer is lost.

Partial:
When structure fetches 10 bytes but in database the end of field marker is not there. The possible reason in my mind is VARCHAR2 column. (again, I do not know what is the End-of-field mark for VARCHAR2 data types, the rest I presume are fixed length fields)

Perhaps this would help

 -----Original Message-----

From: 	Kamesh.J.Mantri_at_citicorp.com [mailto:Kamesh.J.Mantri_at_citicorp.com] 
Sent:	Friday, October 20, 2000 8:22 AM
To:	abchaudhary-ho_at_beaconhouse.edu.pk
Subject:	RE: Urgent : Problems with Pro*C Code

Yes, we use a structure to hold the record. We select the record from the table
into this structure.
Basically the select is supposed to return only one row as the table conatins
identical rows.

Thanks
Kamesh

-----Original Message-----
From: abchaudhary-ho [mailto:abchaudhary-ho_at_beaconhouse.edu.pk] Sent: Thursday,October 19, 2000 8:06 PM
To: ORACLE-L
Cc: abchaudhary-ho
Subject: RE: Urgent : Problems with Pro*C Code

Just came to mind, does your Pro*C code involve Direct Memory Access and/or structures to hold records?

 -----Original Message-----
Sent: Wednesday, October 18, 2000 4:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent : Problems with Pro*C Code

This is almost impossible to answer.

The first thing I would check is to make sure all your variables declarations are large enough to
hold the data. It is obvious you are trashing on memory somewhere. All C programmers has been
has been there on more than one occassion. If you are satisified with your declarations then you will either have to use the debugger to
step through to see where memory is getting corrupted. Sometimes instead of debugging I often comment out suspect code and run. If it works add a little
back in at a time.

Rick

> -----Original Message-----
> From: Kamesh.J.Mantri_at_citicorp.com [SMTP:Kamesh.J.Mantri_at_citicorp.com]
> Sent: Wednesday, October 18, 2000 6:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Urgent : Problems with Pro*C Code
>
> Hi Listers,
> We are running Oracle 7.3.4 on HP-UX.
> My server has Pro*C code which selects some records from a table in the
> database.
>
> The select syntax with bind varaibles is fine.
> The server runs fine for many hours continously. But after sometime the
> same
> select on the same table
> with the same data in the table gives any of these errors..
>
> ORA-02112 "too many rows"
>
> or
>
> ORA-01036 "illegal variable name/number"
>
>
> Sometimes if the select is successful the values filled into bind
> variables are
> garbage.
>
> Cud anyone help us in this regard asap.
>
> Thanks
> Kamesh.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Kamesh.J.Mantri_at_citicorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: abchaudhary-ho_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may