Home » Developer & Programmer » Precompilers, OCI & OCCI » What is OCI_BATCH_ERRORS and BATCH ERROR Mode (Oracle 9i)
What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445970] Thu, 04 March 2010 23:26 Go to next message
jitendra.prakash
Messages: 8
Registered: October 2009
Junior Member
Hi,

Anyone can help me for the same :

what is OCI_BATCH_ERRORS and BATCH ERROR Mode ?
and how the user can set it ?

Regrads,
Jitendra
Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445984 is a reply to message #445970] Fri, 05 March 2010 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&source=hp&q=oracle+OCI_BATCH_ERRORS+&aq=f&aqi=&aql=&oq=

Regards
Michel
Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445996 is a reply to message #445970] Fri, 05 March 2010 01:34 Go to previous messageGo to next message
jitendra.prakash
Messages: 8
Registered: October 2009
Junior Member
Hi Michel,

I went through the link suggested by u.......
but did not understand enough to resolve the below issue.

In my procedure i am doing bulk collect ...save exception
for 10000 records.
and I am getting this exception

ORA-38902: errors in array insert exceed 10000

Can u suggest me to resolve this issue ?

[Updated on: Fri, 05 March 2010 01:35]

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445998 is a reply to message #445996] Fri, 05 March 2010 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-38902: errors in array insert exceed %s
 *Cause: The operation failed because the array INSERT had more errors
         than can be stored internally for BATCH ERRORs.
 *Action : Do not use BATCH ERROR mode when array INSERT has
           more error rows than the number specified in the error.

Regards
Michel
Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446018 is a reply to message #445998] Fri, 05 March 2010 03:03 Go to previous messageGo to next message
jitendra.prakash
Messages: 8
Registered: October 2009
Junior Member
Hi Michel,

I tried to find BATCH ERROR mode in v$parameter, but there is no parameter like this.

How we can disable the BATCH ERROR mode ?



Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446028 is a reply to message #446018] Fri, 05 March 2010 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle® Call Interface Programmer's Guide,
Chapter 4 Using SQL Statements in OCI
Section Executing Statements
Paragraph Batch Error Mode

You have to note that all answers I gave is just a simple search in Google or Oracle documentation.
I knew NOTHING about your question before you post it, never heard about this parameter.
I think you should find the same thing by searching yourself (or I am a real genius).

Regards
Michel

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446032 is a reply to message #445970] Fri, 05 March 2010 04:25 Go to previous message
jitendra.prakash
Messages: 8
Registered: October 2009
Junior Member
Thanks Michel for all u did.
And I also done the same .......
But still me too did not get the solution for the same.

[Updated on: Fri, 05 March 2010 04:25]

Report message to a moderator

Previous Topic: OCIDBStartup() ORA-01078 failure in processing system parameters
Next Topic: Variable Declarations in the DECLARE SECTION;
Goto Forum:
  


Current Time: Mon Nov 11 00:56:22 CST 2024