Re: PL/SQL Records/Tables

Mark D Powell wrote:
> I should have posted an example using "index by binary integer".
> This type is actually the type I mentioned being like procedural language arrays.

Or in 9i, INDEX BY PLS_INTEGER, if only to show that we were paying attention when Oracle said (for ten years or so) that PLS_INTEGER was more efficient than BINARY_INTEGER and should be used in its place wherever possible, although nobody ever did of course. For one major version we actually got a chance to use it before they gave up and made them the same thing, and I for one like to savour the moment.

It won't actually make any difference in this example though, and in fact I seem to remember reading that the optimizer had already started silently replacing one with the other in 9i anyway, which perhaps is what Oracle should have done in the forst place.

Regarding Forms, "INSERT_RECORD", "NEXT_RECORD", etc refer to records in a Forms block, i.e. a group of records displayed on the GUI screen (or "canvas" I think they call it, sorry it's been a while), which has no equivalent in server-side PL/SQL. Received on Mon Mar 27 2006 - 08:56:49 CST