declare
cursor c is
select
c1,c2....
from table1, table2
where table1.col1 = tab2.col1;
begin
TYPE T_c IS TABLE OF C%ROWTYPE INDEX BY PLS_INTEGER;
v_c T_c;
OPEN C;
LOOP
FETCH C BULK COLLECT INTO v_c LIMIT 500;
FORALL i IN 1..v_c.COUNT
INSERT INTO target_table VALUES v_c(i);
COMMIT;
EXIT WHEN C%NOTFOUND;
END LOOP;
CLOSE C;
COMMIT;
end;
/
I just added a two new columns to target_table and also in cursor select..the data types match for those two.
why am i getting ORA-24344: success with compilation error
PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
[Warning] ORA-24344: success with compilation error
295/5 PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
295/5 PL/SQL: SQL Statement ignored
(30: 0): Warning: compiled but with compilation errors