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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.