How packaged procedures and functions are called from the following?

a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME (arguments); EXEC SQL EXECUTE b. BEGIN PACKAGE NAME.PROCEDURE NAME (parameters) variable := PACKAGE NAME.FUNCTION NAME (arguments); END; END EXEC; c. EXECUTE PACKAGE NAME.PROCEDURE if the procedures does not have anyout/in-out parameters. A function can not be called.

Interview Candidate
Sep 9th, 2004
10
4241

PL/SQL

Answer

Showing Answers 1 - 10 of 10 Answers

gigopi
Profile Answers by gigopi

Jul 19th, 2006

?Stored procedure or anonymous block
!packagename.procedurename(paramter...)
? Sql Plus Env
! Execute pack.procedure procedurename(params...)
Krish

idonknowyou
Profile Answers by idonknowyou

May 22nd, 2007

An anonymous block is not named, so it can never be called from outside functions or procedures or calling environment

A function residing in a package can also be called from a Calling environment, provided the it is a public function that is specified in the package specification

Syntax is EXECUTE :return_Variable := <Function_name> as part of SQL Expression

g_sidhu
Profile

Feb 16th, 2008

a. PACKAGE NAME.PROCEDURE NAME (parameters);
    variable := PACKAGE NAME.FUNCTION NAME (arguments);

b.
     BEGIN
     PACKAGE NAME.PROCEDURE NAME (parameters)
     variable := PACKAGE NAME.FUNCTION NAME(arguments);
     END;
     END EXEC;
c. EXECUTE PACKAGE NAME.PROCEDURE
   VARIABLE g_salary NUMBER
EXECUTE :g_salary := get_sal(117)

shi_fu
Profile Answers by shi_fu

Nov 30th, 2010

a. procedure is called by its name:
pack_name.proc_name;
function is called from a expression:
a=b*(function(param));
b.(same as above)
procedure is called by its name:
pack_name.proc_name;
function is called from a expression:
a=b*(function(param));

c.procedure is called like:
execute proc_name; or exec proc_name;
we cannot call a funtion from sql*plus.