Any details on hint SYS_DL_CURSOR ? i.e. what it does and what it’s for?
I see this hint in INSERT statements generated by informatica with bulk load enabled.. I guess it may be using SQL*load or OCI direct path API internally..
INSERT /*+ SYS_DL_CURSOR */ INTO TRAN
("CKEY","LNUM","ACTNBR") VALUES
(NULL,NULL,NULL)
Are these inserts "Direct level insert"as hints Imply? Why do I see NULL in the VALUES clause even though data is there for every row? Is it same as APPEND hint? Oracle documents says INSERT… VALUES can not be DIRECT level INSERTs. So little puzzled.
Thanks
Max.