8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Using the TABLE Operator with Locally Defined Types in PL/SQL


Anil said...

Is ForAll better or table operator now for updates?

Tim... said...

Hi.

You can't update against a table function. Perhaps you mean INSERT INTO ... SELECT, in which case you could use this for the SELECT, for use an INSERT in a FORALL. They both have different pros and cons, so there is not a "better" one. It depends.

Cheers

Tim...

Tim Thompson said...

Hi,
Just noticed a complication that took an hour or so to figure out:

If one of the columns in the rowtype is a float then casting the array to a table will work, but you will be unable to reference the columns in it. To solve this create a record of the same structure but substituted a number for the float and use the record type to define the associative array rather than a row type.

Tim

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!