This discussion is archived
3 Replies Latest reply: Sep 3, 2013 6:41 AM by Neimad RSS

Forms Libraries : Package with function returning collections?

Neimad Newbie
Currently Being Moderated

Hi,

I have a forms library that i have created a package to manage a collection

in this package, i can add item to my collection

but i would like to have another function to return my collection, how is it possible?

 

For now i have tryed something like this :

In my BODY PACKAGE

 

TYPE tvItem is table of varchar2(100) index by pls_integer;
 mycollectiontvItem;
 
function getCollection return tvItem is
  begin
  
    return mycollectiontvItem;
  end;

 

and in my PACKAGE DECLARATION

function getCollection return tvItem;

 

but tvItem is not declared.  is it possible to return the collection?

 

thanks for your help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points