can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swapna
while creating a procedure body we can call other procedure
in that body
for example if your creating the procedure body p1 we can
call the procedure p2 in the procedure body p1
syntax
create or replace procedure p1(a number) is
b number;
begin
p1(10);-- calling first procedure
end;
when you execute procedure p1
exec p1(10) -- it will execute both p1 and p2
Is This Answer Correct ? | 9 Yes | 9 No |
can i give user defined exception in a package
What are the basic techniques of indexing?
what is meant by databases
How to make a copy values from one column to another in sql?
is it mandatory to select all the column in a view then what columns should be selected
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
What is sql stand for?
What is null in pl/sql?
is mysql query is case sensitive? : Sql dba
What is delimiter in pl sql?
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
What are Anti joins