• 139
    1

    FORM_SUCCESS in Oracle D2k DescriptionReturns the outcome of the action most recently performed during the current Runform session.Outcome Returned Valuesuccess TRUEfailure FALSEfatal error FALSESyntax FUNCTION FORM_SUCCESS;Built-in Type unrestricted functionReturn Type:BOOLEANEnter Query Mode yesParametersnoneUsage Notes· Use FORM_SUCCESS to test the outcome of a built-in to determine further processing within anytrigger. To get the correct results, you ...
  • 241
    0

    Obtaining Query Count Without executing a Query in Oracle D2k Obtaining a count of records that will be retrieved by EXECUTE_QUERY before actually performing it in a database block is especially useful when the requirement is to prevent navigation to a block when query hits are zero. A typical scenario of such a situation is ...