473,408 Members | 2,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Maximum open cursor

when I m try to insert more the 300 date at a time from .NET then some error throw Maximum open cursor, so i m increase the size of OPEN_CUSRSORS =1000 instead of 300 from init.ora and restart database,
so again throw same error , Pz give me sol. ASAP
Apr 23 '12 #1
0 1574

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Rahul Sachan | last post by:
Dear All, We are using Oracle 9i databse and Oracle JDBC Driver version - 9.0.2.0.0(oracle.jdbc.driver.OracleDriver) with JDBC 2.0. 1) The following block of statement returns 0 when executed....
3
by: Deepali Gupta | last post by:
We are encountering the problem of "maximum open cursors exceeded" exception. Our web based system uses jdk1.3 as frontend with Oracle 9i as backend and Oracle JDBC Driver version - 9.0.2.0.0...
0
by: Bang | last post by:
Hi All, Recently I installed unixODBC(2.2.3) and MySql and MyODBC on Redhat 9.0. After the installation, I am able to use test program isql to connect to the database I created with mysql. ...
3
by: robert | last post by:
don't find any mention on either udb/APARS or 390/APARS. since upgrading 390 to 7.1.1 over the weekend, the following now happens, when run from udb to 390: .... Statement stmt =...
1
by: Adam Right | last post by:
Hi, I am developing a program with visual studio 2005 beta using C#. I have a problem about opened cursors on my Oracle 9i database. I cannot dispose opened cursors although there is a close...
1
by: suresh8447 | last post by:
I would like to know is there any way to find the maximum open cursor limit set by using OCI, C++ application and reset with some other value Thanks in advance
1
by: jmaria | last post by:
Hello Sorry, I don't find a specific forum for DB2, please help me with this. The cursor don't open :-(, I don't know why, any ideas? I want to update the colum "co_peticion" from table...
5
by: Patrick | last post by:
Hi all, In my SQL procedures in DB2 8.2, I current declare several cursors that return select statements with 10 columns in it. As a result, assigning host variables becomes a coding mess, as...
0
by: skchonghk | last post by:
Dear Experts, In a table UDF, do you know how to open cursor to the resultset returned by stored procedure? Thanks!!!
0
by: Joe | last post by:
I am having difficulties with closing cursors after using select. can somebody give me a hand? Dim OraSession = CreateObject("OracleInProcServer.XOraSession") Dim MyDatabase =...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.