Hi,
I have a package that was already created and was being used. I needed to compile it for debug. It then started generating the above error. Here is the function with the error:
FUNCTION get_point_info (
p$csi_point_name IN lims_extract.csi_point_id%TYPE,
pr$point_info IN OUT abstract_point_definition@wis_dom%ROWTYPE <--- This is the line of code causing the problem.
)
RETURN NUMBER IS
-- v$method_code result.method_code%TYPE;
BEGIN
SELECT *
INTO pr$point_info
FROM wis_dom.abstract_point_definition@wis_dom p
WHERE p.name = p$csi_point_name;
RETURN ge$success;
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END;
Why is this causing a problem now? I am using SQL Developer 4.1.3 and Oracle 11.2.0.4.0.
Thank You,
Tracy