Explain how procedures and functions are called in a PL/SQL block ?

Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

Interview Candidate
Sep 9th, 2004
4
4961

PL/SQL

Answer

Showing Answers 1 - 4 of 4 Answers

M.KUMARAN

Nov 12th, 2005

Function is called as part of an expression.
   sal := calculate_sal ('a822');
   procedure is called as a PL/SQL statement
   calculate_bonus ('A822');
KKK

idonknowyou
Profile Answers by idonknowyou

May 22nd, 2007

Procedure can be called in the following ways

a) CALL <procedure name> direc

b) EXCECUTE <procedure name> from calling environment

c) <Procedure name> from other procedures or functions or packages

Functions can be called in the following ways

a) EXCECUTE <Function name> from calling environment. Always use a variable to get the return value.

b) As part of an SQL/PL SQL Expression