Checking field values in on-validate trigger with SQL cursors

From: <extdrv_at_rcum>
Date: 29 Nov 94 11:17:10 +0200
Message-ID: <1994Nov29.111710.600_at_rcum>

        My problem is cheking field values in on-validate-triiger or post-change
 trigger in V3 forms.

I use following two methods for chekincg of existing values in some table:

1.
Function CheckSomething( FieldValue ) Return boolean is  dummy varchar2( 1 );
 Res boolean;
Begin
--

 Select 'x' Into dummy
   From Something A
  Where A.Id = Field Value;  

 return( TRUE ) ; -- everything is ok
--

 EXCEPTION
  When NO_DATA_FOUND then
    return( FALSE );
  When OTHERS -- some sever error
   message( sqlerrm );
   raise FORM_TRIGGER _FAILURE;    

End;

2. Function SomethingOK( Field in varchar2 ) return boolean is

    Res boolean; Dummy varchar2( 1 );
    CURSOR p_c IS

      SELECT 'x'
        FROM Something A
       Where A.Key = Field;

Begin
--

  open p_c; FETCH p_c INTO dummy;
  if ( not p_c%found ) then
   Res:=false
  else
    Res:=true;

   end if;

    close p_c
    return Res;
  --
   EXCEPTION
     When others then -- unpredictable errr  

           message( sqlerrm ); rasie FORM_TRIGGER_FAILURE; End;

Which method is better in context of performance( parsing and executing )? Pleayour experience... Received on Tue Nov 29 1994 - 10:17:10 CET