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...

I want to execute a piece of code before calling a procedure. How to achieve it?

Answer Posted / abhisekh

we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql pronounced sequel or sql?

1216


What is sql entity?

1031


What are all different types of collation sensitivity?

975


What is null in pl/sql?

1023


What is the difference between alter trigger and drop trigger statements?

1044


What is the difference between rename and alias?

1270


What is sql character function?

996


What sql does db2 use?

928


Can a foreign key be null?

1033


Explain exception handling in pl/sql?

990


What is the least restrictive isolation level? : Transact sql

998


what is uncommittable transactions? : Transact sql

956


What is the cause of mutating table error and how can we solve it?

995


What is trigger explain with example?

985


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901