Dave Mausner
11-05-2003, 05:35 PM
CDOT, it is easy to show that SQL allows creating a nested table column
value containing null elements, and that a non-null element can be updated
to null.
but sql*loader rejects the situation when the input field for an element is
null, giving:
Record 1: Rejected - Error on table T, column C.
NULL nested table element is not allowed
collection element 1
who says it's not allowed? looking at the OCI reference, i observe that when
inserting/updating collections, there's an array of [not]null indicators
passed to the kernel. so everything suggests that null elements are okay,
and loader is balking for a mysterious reason.
ideas anyone, on how to work around it? T.I.A.
--
Dave Mausner / v.+1-708-848-2775 / f.+1-708-848-2569 / c.+1-312-wake-my-i
value containing null elements, and that a non-null element can be updated
to null.
but sql*loader rejects the situation when the input field for an element is
null, giving:
Record 1: Rejected - Error on table T, column C.
NULL nested table element is not allowed
collection element 1
who says it's not allowed? looking at the OCI reference, i observe that when
inserting/updating collections, there's an array of [not]null indicators
passed to the kernel. so everything suggests that null elements are okay,
and loader is balking for a mysterious reason.
ideas anyone, on how to work around it? T.I.A.
--
Dave Mausner / v.+1-708-848-2775 / f.+1-708-848-2569 / c.+1-312-wake-my-i