Previous Topic: Sample Function ProgramNext Topic: Sample CA ADS Procedure


Function Invocation

The following example illustrates invoking the SQL function defined earlier:

SELECT EMP_ID, FIN.UDF_FUNBONUS (EMP_ID   )
  FROM DEMOEMPL.EMPLOYEE
 WHERE EMP_ID = 3411
*+
*+ EMP_ID     USER_FUNC
*+ ------     ---------
*+  3411          5100
*+
*+ 1 row processed