Re: Tables in procedures?

Nils wrote:
: The following code is rejected as invalid... any ideas please, thanks:
 

: create or replace package body brochure is
: procedure broclist
: is
: TYPE v_table IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
: tmp_table v_table;
:
: with the last line being the one rejected.

Try this:

create or replace package brochure as

   TYPE v_table IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;    tmp_table v_table;

   <<etc.>>

end brochure;

create or replace package body brochure is

       procedure broclist

       <<here, you can access tmp_table>>

end brochure;

--
Bob Devereaux
Software and Services Group R&D
HP Fort Collins
1-970-229-3423