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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Turner, Christine
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
