-
EXPORT ROUTINE – SAP-BI
June 24, 2009The concept of Return Table in 3.X we use with Expert Routine in BI. When we have Data Targets where we are feeding most of the Info Objects with the Routine. Note – When we implement Expert Routine it disables Star Routine, End Routine and Transformation Rules. Example Splitting one Record to Multiple Records. SOURCE [...]
-
Exceptions in ORACLE PL/SQL
June 14, 2009Error or Warning of any kind is called as Exception in Oracle which can be predefined or user-defined. Predefined exceptions are raised implicitly by the system. User-defined exceptions must be raised explicitly by RAISE statements. To handle raised exceptions, we write separate routines called exception handlers There are four kinds of exceptions in PL/SQL they [...]