Interested to Buy Any Domain ? << Click Here >> for more details...
can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
- 2 Answers
- 13094 Views
- Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / madhuri
We can call a procedure into another procedure.
create or replace procedure proc1(empno number) is
begin
proc2(20,'CLERK');
end;
When we execute proc1 as follows
exec proc1(7891);
it will execute proc1 and proc2 as well
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
what are integrity rules?
Explain the uses of a database trigger?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is the difference between union and union all? : Sql dba
what is the difference between $message and $$message? : Sql dba
Explain the difference between drop and truncate commands in sql?
How do you create a unique index?
What packages are available to pl/sql developers?
what is the stuff function and how does it differ from the replace function? : Sql dba
what is 'mysqlshow'? : Sql dba
What are sql commands?
Explain the difference between 'between' & 'and' operators in sql
What is difference between table and view?
Why do we use sqlite?
What is the requirement of self-join?
