Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-01009 error on fetch sqlcode 100

Status
Not open for further replies.
Petrus

Petrus

Programmer
Dec 6, 2000
1
GB
on a fetch, the sqlcode is 100 even if it should find rows
the sqlerrmc is: ORA-01009: missing mandatory parameter.
It seems there is a limit in Oracle, the fetch is correct when I pass it alone but it bugs on the 30rd fetch.
The value OPEN_CURSOR is set to 500, we have 30 cursors open.
Any idea on which parameter needs to be set higher ?
 
Status
Not open for further replies.

Similar threads

Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
828
Rasheed Shaik
Rasheed Shaik
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
672
carp
carp
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
178
mibeach7
mibeach7
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
601
Andrzejek
Andrzejek
rk68
  • Locked
  • Question
Data fetch issue thru PL/SQL developer
Replies
4
Views
183
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top