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 -> Re: PL/SQL Question - Passing Arrays

Re: PL/SQL Question - Passing Arrays

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 11 Apr 2005 21:19:03 +0200
Message-ID: <9ajl51t23i8dts86acruig07qhfvmjsct9@4ax.com>


On 11 Apr 2005 11:01:58 -0700, amerar_at_iwc.net wrote:

>.
> FOR i IN 1..p_batd.COUNT LOOP
> IF p_batd.trns_seg = 1 THEN
> v_seq_nbr := v_seq_nbr + 1;
> END IF;
>.
>.
>.
>
>When I try and compile I get the following error:
>
>28/7 PL/SQL: Statement ignored
>28/17 PLS-00302: component 'TRNS_SEG' must be declared
>32/7 PL/SQL: SQL Statement ignored
>
>What am I doing wrong? Any help would be appreciated.

p_batd is a pl/sql table. a pl/sql table is basically an array. Your IF statement is not referring to any element of the array. The syntax to refer to an element is
<table identifier>(<subscriptor variable>)[.record element]

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Apr 11 2005 - 14:19:03 CDT

Original text of this message

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