Q:out paramter in a function???

From: Samer Habib <sha_at_mms-dresden.telekom.de>
Date: 1999/08/18
Message-ID: <37BAD66C.3AA0CB16_at_mms-dresden.telekom.de>#1/1

hi,

I get an error messages if I try to compile the following package.

Package TEST
  IS
  FUNCTION function_name

     ( param1 IN NUMBER,
       param2 OUT NUMBER)
     RETURN BOOLEAN;

END; Package Body TEST
IS

   Function function_name
    ( param1 NUMBER,

      param2 NUMBER)
     RETURN BOOLEAN

    IS
   BEGIN

       select 1 into param2 from dual;
       return TRUE;

   END;
END; Error message:
PLS-00403: expression str cannot be used as an INTO target of a SELECT/FETCH statement

or this error message if I replace the select line with following line:

    param2 := 1;
PLS-00363: expression str cannot be used as an assignment target

thanks

samer Received on Wed Aug 18 1999 - 00:00:00 CEST