can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
Answer Posted / 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 |
Post New Answer View All Answers
Is natural join and inner join same?
Can we insert in sql function?
What is difference between stored procedures and application procedures?
What is sql character function?
What is a memo field?
Can we debug stored procedure?
In pl/sql, what is bulk binding, and when/how would it help performance?
What are the triggers associated with image items?
what is a tablespace? : Sql dba
Which is faster truncate or drop?
Is left join same as join?
What is a table partition?
What are instead of triggers?
Is sql workbench free?
What are different types of statements supported by sql?