8. What is a Raise and Raise Application Error?
Raise statement is used to raise a user defined exception.
A raise application error is a procedure belonging to dbms_standard package. It allows to display a user defined error message from a stored subprogram.
What is the difference between Package, Procedure and Functions?
A package is a database objects that logically groups related PL/SQL types, objects, and
Procedure is a sub program written to perform a set of actions and can return multiple values.
Function is a subprogram written to perform certain computations and return a single value.
Unlike subprograms packages cannot be called, passed parameters or nested.
How do you make a Function and Procedure as a Private?
A) Functions and Procedures can be made private to a package by not mentioning their declaration in the package specification and by just mentioning them in the package body.
What is an Anonymous block?
A) Anonymous Block is a block of instructions in PL/SQL and SQL which is not saved under a name as an object in database schema. It is also not compiled and saved in server storage, so it needs to be parsed and executed each time it is run. However, this simple form of program can use variables, can have flow of control logic, can return query results into variables and can prompt the user for input using the SQL*Plus '&' feature as any stored procedure.
12. What are the two basic parameters that we have to pass while registering PL/SQL procedure?
A) Error code and Error Buffer.
How do you kick a Concurrent program from PL/SQL?
A) Using FND_SUBMIT.SUBMIT_REQUEST.
How to display messages in Log file and Output file?
A) Using FND_FILE.PUT_LINE
What is a Trigger ? How many types of Triggers are there?