PL/SQL: Return types of Result Set variables or query do not match
REF CURSOR 变量的返回类型与查询实际返回的列不匹配。在从强类型 REF CURSOR 获取数据时会在运行时发生此错误。
SELECT object_name, object_type, status FROM dba_objects WHERE status = 'INVALID' AND object_type IN ('PACKAGE','PACKAGE BODY');SELECT text FROM dba_source WHERE name = 'PACKAGE_NAME' AND type = 'PACKAGE' ORDER BY line;