Re: PL/SQL Function Help

Exactly, like 'Nobody' says, loose the 'BOOLEAN's

Also, you may not need a cursor:

CREATE OR REPLACE FUNCTION did_close_test( v2_msg_io IN OUT VARCHAR2,

rt_pa_i IN s2_person_action%ROWTYPE )

RETURN PLS_INTEGER IS

B_TRUE CHAR(1) := '1'; b_moa_ok CHAR(1) := '0';

n_rc PLS_INTEGER := 0;

BEGIN SELECT B_TRUE   INTO b_moa_ok

 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;

b_moa_ok:=NVL(b_moa_ok,'0');

RETURN n_rc;

END did_close_test;

/

;)

--
Posted via http://dbforums.com