Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Working with VARRAY in PL/SQL
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
![]() |
![]() |