OraFAQ Forum: Precompilers, OCI & OCCI » What is OCI_BATCH

Home » Developer & Programmer » Precompilers, OCI & OCCI » What is OCI_BATCH_ERRORS and BATCH ERROR Mode (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445970]

Thu, 04 March 2010 23:26

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

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445984 is a reply to message #445970]

Fri, 05 March 2010 00:47

Michel Cadot
Messages: 68732
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

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #445996 is a reply to message #445970]

Fri, 05 March 2010 01:34

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

Michel Cadot
Messages: 68732
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

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446018 is a reply to message #445998]

Fri, 05 March 2010 03:03

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 ?

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446028 is a reply to message #446018]

Fri, 05 March 2010 03:33

Michel Cadot
Messages: 68732
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

Report message to a moderator

Re: What is OCI_BATCH_ERRORS and BATCH ERROR Mode [message #446032 is a reply to message #445970]

Fri, 05 March 2010 04:25

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 09:03:19 CST 2025