Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Unanswered: PL/SQL Tables question ???

    hi all

    when I use pl/sql table like this (in forms 6i):

    declare
    type my_table is table of varchar2(500)
    index by binary_integer;

    x my_table;

    begin

    for i in 1..1000 loop
    x(i) := 'pla pla pla pla pla ........';
    end loop;
    .
    .
    .
    .
    end;


    the question is :
    after I finish of using this table,is it necessary to (deallocate) or (delete) or anything like this, so I free my memory,
    if yes >> how i can do this


    thnx

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    You could try:

    x.DELETE;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2004
    Posts
    246
    It's not necessary, becuase the pl/sql table is a local variable, and all local variables are dropped/dealloced/whatever when the local code completes. If it was in a package, then you might want to use "x.delete".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •