Oracle-L: Re:RE: OCI Issue

From: <dgoulet_at_vicr.com>
Date: Wed, 12 Jun 2002 12:02:35 -0800
Message-ID: <F001.0047C56A.20020612120235@fatcity.com>

Christine,

You could be having more than one issue here, which kind of threw me. First ofen is an OCI 7 call, the V8 equivalent is OCIStmtFetch. If your running against an Oracle8 or better database it might be wise to upgrade. Second the programmer passes the number of rows he/she wants fetched from the database. Now if in the past that number was greater than the number of rows in the DB there would have been no problem. Now you may be crashing memory with too many rows.

Dick Goulet

____________________Reply Separator____________________
Author: "Turner; Christine" <christine.turner_at_ips-sendero.com>
Date:       6/12/2002 10:55 AM

I was just updated by the developers, the OCI (ofen) call is performing ONLY a select statment, not a create table. Would this make a difference?

thanks,
C-

-----Original Message-----
Sent: Wednesday, June 12, 2002 10:57 AM
To: Multiple recipients of list ORACLE-L

Christine,

Lets see, IF I remember my OCI correctly you pass the OCI function a character variable that holds the SQL statement. Is that variable large enough
for the statement and is it NULL terminated? I seem to remember an OCI program
written by our CIM group that ran into this problem and the NULL terminator was
the problem. Actually where it was was the problem, off the far end of the variable.

Dick Goulet

____________________Reply Separator____________________
Author: "Turner; Christine" <christine.turner_at_ips-sendero.com>
Date:       6/12/2002 9:05 AM

Does anyone know anything about an ORA-1043? We are currently getting it within our OCI layer with the application trying to perform a create table statement with a select statement. We have issued a tar with Oracle, they suggested the 81730 patch, which fixed one computer but not another. Now Oracle wants a test case, which we can not provide. Same app, same database, etc. We are running Oracle 81730, standard edition on a Windows 2000 platform.

Any help and info is greatly appreciated!

thanks,
Christine
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Turner, Christine
INET: christine.turner_at_ips-sendero.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:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------