Which of the following is not a characteristics of stored subprogram?

Options
- Can be called from any block submitted by a user who has EXECUTE privileges on the subprogram
- The compiled p-code can be pinned in the shared pool
- When a stored procedure is called it needs to be compiled
- Packaged subprograms can be overloaded within the same package

CORRECT ANSWER : When a stored procedure is called it needs to be compiled

Discussion Board
Stored subprograms

Subprograms are named PL/SQL blocks that can take parameters and be invoked. If the subprogram has parameters, their values can differ for each invocation. A subprogram is either a procedure or a function. Typically, you use a procedure to perform an action and a function to compute and return a value. It can be called from any block submitted by a user who has EXECUTE privileges on the subprogram. The compiled p-code can be pinned in the shared pool. Packaged subprograms can be overloaded within the same package.

Prajakta Pandit 02-23-2017 07:01 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲