indicator variable with an user defined object
In OCI, I am sending Oracle a query and would like to use indicator variable to
detect null value. The third column in my query is a nested table of user defined
object. For this third column, I already has OCITypeByName/OCIObjectNew to create
define variable and OCIDefineByPos/OCIDefineObject to define output variable.
But in OCIDefineObject call, what kind of indicator variable should I use? If an
array of indicator should be used here, what's the size of this array?
detect null value. The third column in my query is a nested table of user defined
object. For this third column, I already has OCITypeByName/OCIObjectNew to create
define variable and OCIDefineByPos/OCIDefineObject to define output variable.
But in OCIDefineObject call, what kind of indicator variable should I use? If an
array of indicator should be used here, what's the size of this array?
My query is:
SELECT
c.cust_id,
c.cust_name,
(SELECT
CAST
(
COLLECT
(
ord_obj(
o.ord_id,
to_char(o.ord_date, 'YYYYMMDD'),
0