Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tables in procedures?

Tables in procedures?

From: Nils <nils_at_bourbon>
Date: 1997/11/24
Message-ID: <65c9r5$vf6@bourbon>#1/1

Do tables work the same way in procedures as they (according to the book at least) do in standalone blocks?

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.

Nils Received on Mon Nov 24 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US