Thought so. After looking at it again, I saw that he wanted something else.


-----Original Message-----
Sorry John,
But what Ron is trying to accomplish is *NOT* to update the table as You did
but update a collection variable.
In your below example that would be updating *array*.....





**********************************************************
DISCLAIMER: This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the sender
by replying to this message and then delete it from your system. Use,
dissemination or copying of this message by unintended recipients is not
authorized and may be unlawful. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company. Finally, the recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.





Oracle LazyDBA home page