Help with ORA-00932: inconsistent datatypes: expected - got -
636959May 22 2012 — edited May 24 2012Hi Friends -
I am getting an error in the concurrent program when I am executing this piece of pl/sql code - It is surprising that it was working fine 2 weeks ago, but started giving the error ( mentioned in subject) from last week...
I matched the select statement in dr202emplpim.sql ( refer below) to the record type, but no clues...please help.
declare
l_sql_statement VARCHAR2(32767);
TYPE rectype_202 IS RECORD (employee_number per_all_people_f.employee_number%TYPE
,national_identifier VARCHAR2(11)
,last_name per_all_people_f.last_name%TYPE
,first_name per_all_people_f.first_name%TYPE
,middle_names per_all_people_f.middle_names%TYPE
,suffix per_all_people_f.suffix%TYPE
,title per_all_people_f.title%TYPE
,pin VARCHAR2(8) );
rec_202 rectype_202;
l_ucx_info VARCHAR2(72);
cur_202 dynamic_cursor;
BEGIN
l_sql_statement := dbms_xslprocessor.read2clob('DR_SQL','dr202emplpim.sql');
OPEN cur_202 FOR l_sql_statement;
LOOP
FETCH cur_202
INTO rec_202;
....