Interested to Buy Any Domain ? << Click Here >> for more details...
How packaged procedures and functions are called from the
following?
- 2 Answers
- 6249 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the usage of the distinct keyword?
Why stored procedure is faster than query?
How long it takes to learn pl sql?
Why is normalization important?
Is sql free?
What are character functions?
Can we use pl sql in mysql?
What is a behavioral trigger?
What are types of joins?
Does oracle roll back the transaction on an error?
Differentiate between % rowtype and type record.
Explain select statements in sql?
What is the difference between left outer join and left join?
What is the difference between database trigger and stored procedure?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
