| Orackle Package [message #37553] |
Thu, 14 February 2002 00:42  |
roy tilakraj
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
AS
PROCEDURE RestrictionsByCountryID(intCountryID IN Country_restricted_item_cat.country_id%type,
ItemID OUT typeItemID,
ItemName OUT typeItemName
)
IS
CURSOR Cursor_Restriction IS
SELECT CRIC.item_m_cat_id CATID , IMC.ItemMainCatName CATNAME
FROM country_restricted_item_cat CRIC , item_main_category IMC
WHERE CRIC.Country_Id = intCountryID
AND CRIC.item_m_cat_id(+) = IMC.ItemMainCatId
Order By country_id;
intCount NUMBER DEFAULT 1;
BEGIN
FOR Cursor_SingleRestriction IN Cursor_Restriction
LOOP
ItemID(intCount) := Cursor_SingleRestriction.CATID;
ItemName(intCount) := Cursor_SingleRestriction.CATNAME;
intCount := intCount + 1;
END LOOP;
END;
END;
I HAVE THE ABOVE PROCEDURE IN ONE OF THE PACKAGES AND WHEN I TRIED TO CALL IT FROM VB,IT GIVES THE FOLLOWING ERROR
"[[Microsoft]][[ODBC driver for Oracle]][[Oracle]]ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array
ORA-06512: at line 1"
It works fin in SQL PLUS prompt
What is wrong with this ?
|
|
|
|
| Re: Orackle Package [message #37557 is a reply to message #37553] |
Thu, 14 February 2002 01:07  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
check the arraysize in VB.
=================
ORA-06513 PL/SQL: index for PL/SQL table out of range for host language array
Cause: An attempt was 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, and so on. If a table entry was not assigned, then the corresponding element in the host language array is set to NULL.
Action: Increase the size of the host language arrays or decrease the size of the PL/SQL table. Also make sure that you do not use index values less than 1.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
