error in Oracle function

[Sharma Ashutosh]

Hi,
I'm trying to use a stored procedure-a function which cud accept the array of longs and return me the resultSet.
After doing a lot of investigation on the web-i can successfully pass the array but while executing the code via SQL*Plus or Java/JDBC i m keep on getting this error:

SQL> create or replace type NUM_ARRAY as table of number;
SQL> create or replace function getStack(bbid_array in num_array) return types.cursortype
  2  as
  3  l_cursor types.cursorType;
  4  begin
  5  for i in 1 .. bbid_array.count
  6  loop
  7  open l_cursor for select fc__keytable_1077.keyorder, fc__keytable_1077.keyvalue from fc__keytab
le_1077 where 
  8  fc__keytable_1077.bbid = bbid_array(i);
  9  end loop;
 10  return l_cursor;
 11  end;
 12  /
 
Warning: Function created with compilation errors.
 
SQL> select line, position, text from user_errors;
 
      LINE   POSITION
---------- ----------
TEXT
--------------------------------------------------------------------------------
         1         57
PLS-00302: component 'CURSORTYPE' must be declared
 
         0          0
PL/SQL: Compilation unit analysis terminated
 

Can someone help me what to do?

[Sharma Ashutosh]

Got the answer-one shud declare these kind of declaration in the create/replace package

[Jeanne Boyarsky]

Monu,
Thanks for posting the answer.
[ May 21, 2005: Message edited by: Jeanne Boyarsky ]