Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?

Question Posted / swapna

Answers were Sorted based on User's Feedback



can we call a procedure into another procedure?If yes means how you can pass the perameters for t..

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

can we call a procedure into another procedure?If yes means how you can pass the perameters for t..

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

Post New Answer

More SQL PLSQL Interview Questions

What is a sql select statement?

0 Answers  

What is the purpose of cursors in pl/sql?

0 Answers  

What are the disadvantages of file system?

0 Answers  

how many groups of data types? : Sql dba

0 Answers  

what are the t string functions available in tsql? : Transact sql

0 Answers  

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

How to access the current value and next value from a sequence?

6 Answers  

How do I start pl sql?

0 Answers  

What is procedure and function in sql?

0 Answers  

What is record variable?

0 Answers  

What does where 1 1 mean in sql?

0 Answers  

How many subqueries can be nested in a statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories