PL/SQL Function Help
From: Larry Lowe <llowejr_at_usa.net>
Date: 19 Aug 2003 06:03:47 -0700
Message-ID: <ad17577.0308190503.3054d087_at_posting.google.com>
Date: 19 Aug 2003 06:03:47 -0700
Message-ID: <ad17577.0308190503.3054d087_at_posting.google.com>
The following function worked in 8i(8.1.7.4) but will not compile in
9i(9.2.0.3). This is a stripped down version with just the error
parts. I am really new at PL/SQL can someone help me out.
Thanks
CREATE OR REPLACE FUNCTION did_close_test( v2_msg_io IN OUT VARCHAR2,
rt_pa_i IN s2_person_action%ROWTYPE )
Larry
RETURN PLS_INTEGER
IS
B_TRUE BOOLEAN := TRUE; b_moa_ok BOOLEAN := FALSE; n_rc PLS_INTEGER := 0;
CURSOR c_mon IS
SELECT B_TRUE
FROM s2_action_monitor
WHERE moa_received_date IS NOT NULL
AND moa_signed_date IS NOT NULL
AND person_action_key = rt_pa_i.process_person_action_key;
BEGIN
OPEN c_mon;
FETCH c_mon INTO b_moa_ok;
CLOSE c_mon;
RETURN n_rc;
END did_close_test;
/
Received on Tue Aug 19 2003 - 15:03:47 CEST