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

Home -> Community -> Usenet -> c.d.o.tools -> Working with VARRAY in PL/SQL

Working with VARRAY in PL/SQL

From: Rolf Kamp <rfk_at_exit109.com>
Date: Fri, 29 Dec 2000 19:53:41 -0500
Message-ID: <3A4D3215.48B5062A@exit109.com>

Hi:

    I need to use a VARRAY in a stored procedure and need some help. I have a 'site' table that refers to a 'priceplan' table which has a VARRAY that I need to make comparisons against. I have tried a number of things to look at each of the 'rate_t' objects in the ratetable VARRAY, but am not getting the syntax correct. Below is a description of the pertinent tables/fields/objects.

    How do I look at each of the 'rate_t' objects in a given ratetable if I know the correct record to use in the pricplan table (I know the SID and therefore the PPID).

    Any help is greatly appreciated. Thanks! - Rolf

Site table:

SID                                     NOT NULL NUMBER(8)
PPID                                    NOT NULL REF OF PRICEPLAN_T

Priceplan table:
PPID                                    NOT NULL NUMBER(8)
RT_CONTINUOUS                         NOT NULL RATETABLE
RT_EVENT                                NOT NULL RATETABLE
RT_PEAK                                 NOT NULL RATETABLE

ratetable VARRAY(20) OF RATE_T
 RATELEVEL                                        NUMBER(3)
 CHARGE                                           NUMBER(15,2)
Received on Fri Dec 29 2000 - 18:53:41 CST

Original text of this message

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