Re: Appending rows to a cursor

From: <india477_at_my-dejanews.com>
Date: Tue, 01 Sep 1998 14:47:42 GMT
Message-ID: <6sh1ee$ial$1@nnrp1.dejanews.com>

I do no think you can do that. Cursors are handles to result sets created from a select statement and the rows depend on the where conditions of the statment.

What you could do is use PL/SQL tables. They are like arrays in other programming languages.

They need to be defined inside PLSQL packages are typically used by stored procedure and functions.

	TYPE char1_array IS TABLE OF CHAR(1)
	INDEX BY BINARY_INTEGER;

you can declare a variable of this type:
               alphabets char1_array;

then append values into it by:
               alphabets[0] = 'A';
               alphabets[1] = 'B';
               alphabets[2] = 'C';
               alphabets[3] = 'D';

Hope this helps.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 01 1998 - 09:47:42 CDT