3 Replies Latest reply: Sep 3, 2013 8:41 AM by Stephane Baribeau RSS

    Forms Libraries : Package with function returning collections?

    Stephane Baribeau

      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.