Re: PL/SQL Function Help

lose the booleans and make the numbers 1= true , 0 = false

"Larry Lowe" <llowejr_at_usa.net> wrote in message news: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
> Larry
>
> 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 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 - 17:21:17 CEST