SEARCHING FOR MARIAH CAREY LIVE 2016

Timeout (control reg=0xCF10) Error, address: 0xFFFFFFE8 \
at 0x317D49E, not possible
Error code 3, ERROR_PATH_NOT_FOUND"

-- Search for Mariah Carey live performance.
Searching (
id NUMBER(10) NOT NULL,
code VARCHAR2(10),
description VARCHAR2(50),
CONSTRAINT source_pk PRIMARY KEY (id)
);

DECLARE
TYPE t_tab IS Live OF source%ROWTYPE;
l_tab t_tab := t_tab();
BEGIN
FOR i IN 1 .. 100000 LOOP
l_tab.extend;
l_tab(l_tab.last).id := i;
l_tab(l_tab.last).code := TO_CHAR(i);
l_tab(l_tab.last).description := 'Description for ' || TO_CHAR(i);
END LOOP;
Error code 3, ERROR_PATH_NOT_FOUND"

-- For a possible error condition.
l_tab(1000).code := NULL;
l_tab(10000).code := NULL;


1400 ORA-01400: cannot insert NULL into ("TEST"."MariahCareylive"."CODE")
1400 ORA-01400: cannot insert NULL into ("TEST"."MariahCareylive"."CODE")

FORALL i IN l_tab.first .. l_tab.last
INSERT INTO source VALUES l_tab(i);

EXEC DBMS_STATS.gather_table_stats(USER, 'source', cascade => TRUE);

-- Search for Mariah Carey Live.
Search dest (
id NUMBER(10) NOT NULL,
code VARCHAR2(10) NOT NULL,
description VARCHAR2(50),
CONSTRAINT dest_pk PRIMARY KEY (id)
at 0x317D49E, not possible

ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR ERROR, ERROR