Re: Retrieving Multiple ROWS wITH pl/sql

From: Geert De Paep <gdp_at_cimad.be>
Date: 1997/05/12
Message-ID: <3376F666.73A0@cimad.be>#1/1

Marc,

Could PLSQL tales maybe help you? Something like (an extract of one of my programs):

cursor DownParChildInfoCur (RepIdPar number) is select * from report_hierarchy
where self_rep_id = RepIdPar;

type DownParChildDescType is
table of DownParChildInfoCur%rowtype
index by binary_integer;

procedure WhatEverProcedure
( DownParChildInfoRec in DownParChildDescType) is
begin
... DownParChildInfoRec(i).colname...

where i is variable and (+/-) unlimited

Geert.

-- 

The next generation of computers will have a "Warranty Expired"
interrupt.
                          ______  ______  __    __  _____  ____
Geert De Paep            / ____/ __  __/         /   __  /  __ |
Cimad Consultants       / /         /     /|_/  /   /_  /  /   /
Groenenborgerlaan 16   / /         /     /     /   __  /  /   /
2610 Antwerpen        /_____/ ______/ __/   __/ __/ __/ _____/
http://www.cimad.be   Email: gdp@cimad.be   Tel: 03/820 82 50

Received on Mon May 12 1997 - 00:00:00 CDT