Can’t use
RETURNING with INSERT
Cannot access types owned by other schemas through synonyms (prior to 9.2)
Remember that with NOT IN, if any member of the list is NULL, the result is NULL
3rd party support
for collections is scanty
Bulk Ops w/Collections of Record (COR): No RETURNING * INTO COR , no access to in-bind COR fields in SQL statement, no NDS except SELECT
No bulk collecting into associative arrays indexed by strings.| The docs say you
can use RETURNING with INSERT, but it doesn’t currently work. “You can use
the BULK COLLECT clause in the RETURNING INTO clause of an INSERT, UPDATE, or
DELETE statement” |
|
| Similarly, there
is no indication that you can’t have shared types accessed through synonyms.
However, if you try it, you will get “ORA-22863 synonym for datatype
schema.type not allowed”. Bug/Enhancement 1879471 has been filed which is off
limits to public. It is fixed in 9.2. |