Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Associative Arrays - Oracle 9i
Kent Brye wrote:
> It's Monday and I'm having a problem grasping how to do something. Does
> anyone have a vanilla example of how to create, fill, cursor off of an
> associative array?
>
> I'm trying to manipulate some text (varchar2 column) for a report to put in
> some line numbers that would be is used in editing. Like in a legal
> document so you can quickly get to line 43 for example. In any event I was
> going to parse the text into a predetermined length (i.e. 80 char wide) and
> put in line numbers. The associative array would have two columns: line
> number and text string. The stored procedure used for the report would have
> a cursor that would select off of the associative array. The stored proc
> would be used in crystal reports for the final output. I'm more than open
> to other ideas.
>
> Thanks in advance,
>
> Kent Brye
> National Conference of Bar Examiners
> kbrye_at_ncbex.org
> voice: (608) 280-8550 ext. 103
> fax: (608) 442-7967
www.psoug.org
Click on Morgan's Library
Click on Associative Arrays
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Dec 12 2005 - 16:12:12 CST