TOAD disappears or crashes, with no warning or error messages, after hitting the "Perform a code quality review of the editor contents" button in the CodeXpert tab for a SQL Editor Window that contains a package body.
For example, paste the following into the SQL Editor Window and hit the above-mentioned button under the CodeXpert tab for TOAD to disappear:
CREATE OR REPLACE PACKAGE BODY pkg_pid_status
AS
FUNCTION f_sel_pid_status (
p_pidclientref pid_status.pidclientref%TYPE
, p_change_datetime pid_status.change_datetime%TYPE
, p_method pid_status.method%TYPE
, p_debug IN INTEGER DEFAULT 0 )
RETURN t_pid_status_cursor
IS
crsrpid_status pkg_pid_status.t_pid_status_cursor;
BEGIN
gvprocedurename := 'f_Sel_PID_STATUS';
gvprocedurestep := 'Validate Args';
gvprocedurestep := gvprocedurestep || 'p_PIDCLIENTREF ' || p_pidclientref;
gvprocedurestep := gvprocedurestep || 'p_CHANGE_DATETIME ' || p_change_datetime;
gvprocedurestep := gvprocedurestep || 'p_METHOD ' || p_method;
IF ( p_debug = 1
OR pkg_epic_error_handler.gcdebug )
THEN
gvepicerror.error_id := 0;
gvepicerror.msg := gvprocedurename || gvprocedurestep;
pkg_epic_error_handler.plogerror ( gvepicerror ); -- Log entry
END IF;
gvprocedurestep := ' Check cursor not open';
IF crsrpid_status%ISOPEN
THEN
CLOSE crsrpid_status;
END IF;
OPEN crsrpid_status FOR
SELECT change_datetime
, epw_processed
, method
, pidclientref
, VERSION
, wpa_processed
FROM pid_status
WHERE pid_status.pidclientref = p_pidclientref
AND pid_status.change_datetime = p_change_datetime
AND pid_status.method = p_method;
RETURN crsrpid_status;
END;
END;
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center