Ora-00932: inconsistent datatypes: expected ROWID got NUMBER
448954Mar 2 2006 — edited Oct 30 2006Hi,
I have a pack in 8i. and migrated to 10.1.0.3. When I compile it is giving above error message.
code is:
FUNCTION is_processed( p_rowid IN NUMBER)
RETURN BOOLEAN
IS
i number(22); -- this line is causing error
BEGIN
select max(rtf_iid) into i from wb_rt_feedback where rte_rowid = p_rowid;
return(TRUE);
EXCEPTION
WHEN OTHERS THEN
return(FALSE);
END is_processed;
Note: rtf_iid is number(22) type.
Error message after compile is:
SQL> show errors
Errors for PACKAGE BODY pk1
LINE/COL ERROR
-------- --------------------------------------------------------------------
97/76 PL/SQL: ORA-00932: inconsistent datatypes: expected ROWID got NUMBER
97/2 PL/SQL: SQL Statement ignored
Can any one help me please?
Thansk,
Bhoopal.