sql loader rejects null elements of nested table -- ??
From: Dave Mausner <net.ameritech_at_dmausner>
Date: Thu, 06 Nov 2003 01:35:44 GMT
Message-ID: <Qzhqb.13292$8x2.6377420_at_newssrv26.news.prodigy.com>
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.
Date: Thu, 06 Nov 2003 01:35:44 GMT
Message-ID: <Qzhqb.13292$8x2.6377420_at_newssrv26.news.prodigy.com>
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-iReceived on Thu Nov 06 2003 - 02:35:44 CET