How packaged procedures and functions are called from the following?

How packaged procedures and functions are called from the
following?

Question Posted / guest

2 Answers
5751 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How packaged procedures and functions are called from the following?..

Answer / rajesh

The package procedure and function are called by using
package name.function/procedure name....

Is This Answer Correct ?

2 Yes

0 No

How packaged procedures and functions are called from the following?..

Answer / madhavi

If A function returns only one value then u can call
that function from select statement like
select packagename.functionname(parameters) from dual,

But for procedure its not possible to call through select
statement u have to call through anonymous block.
declare
begin
packagename.procedurename(actual parameters);
end;
/

Is This Answer Correct ?

2 Yes

0 No

Post New Answer