1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

transfer customer groups into a variable through select

Discussion in 'Oracle Forms and Reports' started by samina, Jan 30, 2013.

  1. samina

    samina Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    in pl/sql reports 6i i wish to store all the distinct customer groups into a variable but im gettin a error:

    function AfterPForm return boolean is
    type array_t is table of varchar2(40);

    begin
    select distinct(customer_grp) into array_t from som_must_stock_list_det where comp_code=:p_COMPANY_CODE;
    end;
    error:inapproprite to use array_t

    can anyone give me a solution pls..
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Re: tranfer customer groups into a variable through select

    Hi Samina

    Try with the following code.. I hope it will help you.

    function AfterPForm return boolean is
    type array_t is table of varchar2(40);

    l_array array_t;

    begin
    select distinct(customer_grp) bulk collect into l_array from som_must_stock_list_det where comp_code=:p_COMPANY_CODE;
    end;


    Regards
    Samba