| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Help: ORA-1001
My coworker runs a program against our Oracle 8.1.5 on Solaris 2.6. It always
throws the ORA-1001 error. But it doesn't abort the execution of the rest of
the program. The description of ORA-1001 is:
ORA-01001: invalid cursor
Cause: Either a host language program call specified an invalid cursor or the
values of the AREASIZE and MAXOPENCURSORS options in the precompiler command
were too small. All cursors must be opened using the OOPEN call before being
referenced in any of the following calls: SQL, DESCRIBE, NAME, DEFINE, BIND,
EXEC,
FETCH, and CLOSE. The Logon Data Area (LDA) must be defined by using OLON or
OLOGON. If the LDA is not defined, this message is issued for the following
calls: OPEN, COM, CON, ROL, and LOGOFF.
Action: Check the erroneous call statement. Specify a correct LDA area or
open the cursor as required. If there is no problem with the cursor, it may be
necessary to increase the AREASIZE and MAXOPENCURSORS options before
precompiling.
Since it's not easy (but maybe possible) to get the source code, I want to know if I can do anything to help. Are AREASIZE referred to in the above description sort_area_size and MAXOPENCURSORS open_cursors initialization parameters? I have no experience in OCI or Pro*C. Thanks for any advice.
Yong Huang
yong321_at_yahoo.com
 |
 |