Home » SQL & PL/SQL » SQL & PL/SQL » ORA-6513
ORA-6513 [message #412856] Mon, 13 July 2009 02:03 Go to next message
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
Member
Hi All

When I am calling one package from the application, I am getting this error. This package is having some out variables which are of type pl/sql table. This error is only coming with the accounts which are using index more than 100. Is there any limit for the biany_integer table index.

ORA-6513 PL/SQL: index for PL/SQL out of range for host language array.


I have searched through google also but could not find much about this error.


Please let me know what can be the cuase and remedy for this error.


Thanks

Regards
b_chugh
Re: ORA-6513 [message #412859 is a reply to message #412856] Mon, 13 July 2009 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any limit for the biany_integer table index

PL/SQL User's Guide and Reference
Chapter 3 PL/SQL Datatypes
Section Overview of Predefined PL/SQL Datatypes
Paragraph BINARY_INTEGER Datatype

Quote:
I have searched through google also but could not find much about this error.

You didn't search very well, a simple search in Error messages book gives:
ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array
 *Cause: An attempt is being made to copy a PL/SQL table to a host language
         array.  But an index in the table is either less than one or
         greater than the maximum size of the host language array.
         When copying PL/SQL tables to host language arrays, the table
         entry at index 1 is placed in the first element of the array, the
         entry at index 2 is placed in the second element of the array, etc.
         If an table entry has not been assigned then the corresponding
         element in the host language array is set to null.
 *Action: Increase size of host language array, or decrease size of PL/SQL
         table.  Also make sure that you don't use index values less than 1.


Regards
Michel

[Updated on: Mon, 13 July 2009 02:18]

Report message to a moderator

Re: ORA-6513 [message #412860 is a reply to message #412856] Mon, 13 July 2009 02:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can you reproduce the problem calling the package from Pl/Sql?
Re: ORA-6513 [message #412865 is a reply to message #412859] Mon, 13 July 2009 02:28 Go to previous message
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
Member
Hi All

Thank for the response. The array variable in the application language was having the maximum index size which was less than what we were getting from the package. I have increased the maximum size of that and it worked.


Thanks all.
Previous Topic: Regarding oracle jobs
Next Topic: How to compile all the Oracle Scripts at one-go?
Goto Forum:
  


Current Time: Mon Dec 05 07:13:54 CST 2016

Total time taken to generate the page: 0.08317 seconds